Linux Oracle Import exports a single table (without a foreign key constraint)

EXPDP:

Sql> Create directory Dir_tables as '/home/oracle/tables ';

Sql> Grant Read,write on the directory dir_tables to user name;

EXPDP system/system password @sid tables= user name. Table name Directory=dir_tables dumpfile=tables.dmp Logfile=tables.log

IMPDP:

Sql> Create directory Dir_tables as '/home/oracle/imp_tables ';

Sql> Grant Read,write on the directory dir_tables to SYS;

IMPDP system/system password directory=dir_tables dumpfile=tables.dmp logfile=tables.log

Note: Cascading is not available, there are tables to delete, drop table Deepdata.risks

Linux Oracle Import exports a single table (without a foreign key constraint)