Hinzinfotech

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.

Step1: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                […]

Explain 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 […]

Step1: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’ […]