PostgreSQL is an free open-source database system that supports both relational (SQL) and non-relational (JSON) queries. PostgreSQL is a back-end database for dynamic websites and web applications. PostgreSQL supports the most important programming languages: Python.
Read MoreOracle Cloud Infrastructure launched in October 2016 with a single region and core services across compute, storage,and networking. Since then, Oracle Cloud has expanded to more than 70 services available in 29 cloud regionsworldwide with plans to reach 38 total regions by the end of 2021. OCI offers relational, OLAP, JSON, and NoSQLdatabases, containers, Kubernetes, […]
Read MoreStep1:Create tablespace and Expdp: SQL> select table_name,tablespace_name from dba_tables where table_name=’BK’; TABLE_NAME ——————————————————————————– TABLESPACE_NAME —————————— BK INBA SQL> select name from v$datafile; NAME ——————————————————————————– /u01/app/oracle/oradata/ORCL/datafile/o1_mf_system_h1lpjm44_.dbf /u01/app/oracle/oradata/ORCL/datafile/o1_mf_sysaux_h1lpl0nb_.dbf /u01/app/oracle/oradata/ORCL/datafile/o1_mf_undotbs1_h1lplsxv_.dbf /u01/app/oracle/oradata/ORCL/datafile/inba01.dbf /u01/app/oracle/oradata/ORCL/datafile/o1_mf_users_h1lplv5f_.dbf SQL> alter user remo default tablespace inba; User altered. SQL> conn remo/remo Connected. SQL> select * from bb; ID ———- 22 23 […]
Read MoreExplain Oracle Architecture?Oracle Instance:a means to access an Oracle database,always opens one and only one database and consists of memory structures and background process.Oracle server:a DBMS that provides an open, comprehensive, integrated approach to information management,Consists of an Instance and a database.Oracle database:a collection of data that is treated as a unit,Consists of Datafiles, Control […]
Read MoreStep1:To create user and table: SQL> conn remo/remo Connected. SQL> select count(*) from emp; COUNT(*) ———- 4 SQL> host Step2:Create Directory and grant permission: SQL>create directory dir as ‘/u01/exportfile’; SQL>grant exp_full_database,imp_full_database to sys,system,remo; SQL> grant read,write on directory dir to sys,system,remo; Grant succeeded. Step3:Export the Dumpfile: [oracle@trichy u01]$ expdp directory=dir dumpfile=bkp_remo.dmp log=bkp_remo.log owner=’REMO’ […]
Read More