This content has been marked as final. Show 3 replies
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