oracle database

create a directory in server and database as follow: [oracle@pavanorcl101 admin ] $ mkdir -p /u01/app/export SQL>create directory exportdirectory as '/u01/app/export'; we are exporting records in   EMP table in KRISHNA Schema with city name 'BHIMAVARAM' SQL> conn krishna Enter password: Connected. SQL> select * from emp;         ID NAME                 CITY ---------- -------------------- --------------------          1 Sai                  Vijayawada          2 Ram                 Vijayawada          3 Pavan                Bhimavaram          4 Krishna             Bhimavaram creating a export par file with required parameters as below [oracle@pavanorcl101 export ] $ vi emp_table.par directory=EXPORTDIRECTORY dumpfile=emp_table.dmp logfile=emp_table.log tables=KRISHNA.EMP query=EMP:"where CITY='Bhimavaram'" Give read, write and execute permissions to the par file: [oracle@pavanorcl101 export ] $ chmod -

Scenario: we have a schema pavan in ORCL(11g) database. A user krishna in another database TEST(12c) want to view the data in pavan schema in ORCL database. solution: create DB link in TEST(12c) database to pavan schema in ORCL(11g) database.   Steps: ------------ ORCL(11g): ---------------- create user pavan and grant required privileges to the user pavan. connect to pavan and create table EMP and insert rows into the table EMP SQL> create user pavan identified by oracle; SQL> grant connect, resource to pavan; SQL> grant unlimited tablespace to pavan; SQL> conn pavan/oracle SQL> create table emp (id number(10), name varchar2(50), dept varchar(20)); SQL> insert into emp values (1, 'krishna','eee'); SQL> insert into emp values (2, 'sai','ece'); SQL> insert into emp values (3, 'trilok','eee'); SQL> insert into emp values (4, 'naresh','eee'); SQL> in