This content has been marked as final. Show 3 replies
*'/test/data/temp08.dbf' SIZE 34359721984 AUTOEXTEND ON NEXT 52428800 MAXSIZE 32767M*32767M is less than 34359721984, and MAXSIZE can't be less than SIZE.
You may try to pre-create that tablespace, changing 32767M with UNLIMITED.
This may be a bug, I'd manually create the tablespaces and then exlcude their creation from the impdp command using exclude= (or just ignore the error when it tries to create them when they are already there).
I'm not sure why there was bad ddl created. I wonder if there is something wrong with the view that is fetching this information from the source database. The problem can be fixed by just creating that tablepace manually. You have the ddl, and if you have a situation where you don't get it all, you can run the import command with:
You can also use the:
to limit what gets written to your sqlfile. Once you get this file, it will contain the list of ddl that would have been executed if the import was run. You can edit the file to get the ddl that you want. If you need to change the ddl, you can do that as well.
I should have added: Once the tablespace is imported,you can run the same import and then add:
or if you are running just a schema or set of schemas, then you don't need to add the exclude since tablespaces are not imported as part of a schema import.
Hope this help.
Edited by: Dean Gagne on Jan 11, 2013 10:35 AM