ORACLE: Export

When you need to transfer data objects between Oracle databases, the Export utility is a handy way to do this. Here is basic Export.txt file where you can use to get started.

Export.txt
------------

userid=[User ID of the user you going to Export]
filesize=[How much you want the Dump file to be Eg:2000MB]
file=[Names of the Dump files…..Eg:DUMP_1.dmp,DUMP_2.dmp……]
log=[Name the log file …Eg:export.log ]
consistent=n
compress=y
rows=y
indexes=y
..
..
..
..
TABLES=[Names of the table you want to Export]

Consistent, compress, rows, indexes there is a lot you can add or change depending on your requirements, like what tables or which partitions you want to Export.

Export is a very advance utility in Oracle any way here is like I said just the basic requirements which will help you get started. =ELK=