The exported file seems to be OK, however when importing the file, the data files in the target database increase far beyond what I expected and filled the disk space.
The original data file is just over 1 GB in size. My available disk space is 28GB, and this is being maxed out. E.g. After importing the first 28 tables, and only approximately 2,500 rows of data, the data file was 8GB in size.
What am I doing wrong?
imp file=my_dump.dmp full=y show=y log=create.sql
The above will generate a file called create.sql which will contain the SQL statements Oracle will execute when creating the tables. Use these to precreate the tables in the destination database with a good INITIAL extent size, not the one in the generated file. Then import with IGNORE=Y.
Dig Deeper on Oracle database backup and recovery
Related Q&A from Brian Peasland
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs. Continue Reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command. Continue Reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. Continue Reading