1. schema refresh – tax.
|
2. abort the session when taking export, restart the export from the interruption add parallel option.
|
3. export all tables from a user without records.
|
4. create export and import without creating dump file (using network link).
|
5. take export of a single column from a table.
|
6. create a table as a copy of all_objects without data. Import the data from dump of the all_objects.
|
7. how will you increase performance of data pump and start the job, stop the job, kill the job,
restart the job,check the status and continue the job.
|
8. clone the TAX schema to tax1 using datapump.
|
9. export the tax dump and import all the tables into user02 without data and without index.
|
10. import the data separately into the user user02.
|
11. import the index separately into user user02.
|
12. read the dump.
|
13. using transport tablespace option complete import and export of dev database.
|
14. read the dump.
|
15. take a dump in 12c and import it into 19c database.
|