Export dump file size
678239Jan 6 2009 — edited Jan 6 2009Hi,
I have to automate the export import process in the production environment.
Table are to be exported from an Oracle 9i database.
The tables are very huge: one table is 44,300,200 MB
Now i understand that i can export the table data to multiple files using something like below
exp userid=robert/robert file = file1,file2,file3,file4,file5 filesize = 500m owner=robert
But since the export import thing has to be automated, I have written java code that calls the exp and imp utility
SO i need to know how many files to provide in the exp command.
is there a way to determine the dump size file by looking at the table size.
all help is greatly appreciated