How to import using impdp into schema without existing tables
Posted on 2009-04-08
I am running impdp on a file to import a schema into my tablespace. My tablespace is called DEMO. The impdp command I am running is:
impdp DEMOUSER/DEMOUSER@dev dumpfile=AR_TABLES.dmp logfile=AR_TABLES.imp.log REMAP_SCHEMA=CRCM_USER:DEMO
All of the tables in the datafile fail as follows:
ORA-31693: Table data object "DEMO"."INDUSTRY_CLASS_CODES" failed to load/unload and is being skipped due to error:
ORA-31603: object "INDUSTRY_CLASS_CODES" of type TABLE not found in schema "DEMO"
Well, of course it's not found, i'm importing the datafile fresh, I haven't created the tables. In fact, I don't even know the DDL to create the tables in the first place, a customer gave me this file.
I tried adding the SQLFILE parameter and it generated a file without any SQL!
Any help please? I can't seem to find anyone who has encountered this problem, so please tell me this is something simple.
We are trying to import into Oracle 11 from an Oracle 10 dump.