It may not be the best method, but personally I like to pre-create the tables by extracting ddl from source, impdp contents=data_only , then build the indexes/constraints, etc..
QUOTE (Drakken @ Feb 13 2012, 04:22 AM)
I'm trying desperately for a few days to import an Oracle database 10.2.0.5 from a Red Hat Enterprise Linux Server release 4.1 on my Windows server 2008 R2 x64 22.214.171.124.
The expdp export is performed without errors with the following options:
DUMPFILE = expinclude.dmp
DIRECTORY = exp_dir
LOGFILE = expinclude.log
TABLES = (list of tables with partitions)
ESTIMATE = STATISTICS
When I try to import my dump I do not get a multitude of errors like this:
ORA-39083: Failed to create the object type TABLE: "VL_DATA". "LOG_VOUCHERS_MESSAGES" with option value error:
ORA-02219: invalid NEXT storage option value
After having scoured the forums on the net I have found very little info on this error (besides the code itself emerges out of a thousand sites).
I tried multiple combinations for Import: excluding the index, only the structure of import, import data, etc. ... without success.
If someone have a track I would be greatly relieved.
Thank you in advance.