"Original" IMP transportable tablespace. IMP wants a datafile?

From: Owen Smith <owensmith99_at_gmail.com>
Date: Sat, 15 Sep 2007 02:37:36 -0700
Message-ID: <b447e8230709150237h9939920t33efbd044e0ad3ba@mail.gmail.com>

Hello Oracle People,

I'm trying to figure out how to import a transportable tablespace I found.

The tablespace contains the "sample schema"

The export file and corresponding database file look like this:

bash sol oracle ~/product/10r2/assistants/dbca/templates 31 $
bash sol oracle ~/product/10r2/assistants/dbca/templates 31 $ pwd


/h/oracle/product/10r2/assistants/dbca/templates

bash sol oracle ~/product/10r2/assistants/dbca/templates 32 $
bash sol oracle ~/product/10r2/assistants/dbca/templates 32 $
bash sol oracle ~/product/10r2/assistants/dbca/templates 32 $ ll example*
-rwxr-xr-x   1 oracle   dba       980992 Jun 27  2006 example.dmp*
-rwxr-xr-x   1 oracle   dba      13115392 Jun 27  2006 example01.dfb*

bash sol oracle ~/product/10r2/assistants/dbca/templates 33 $ bash sol oracle ~/product/10r2/assistants/dbca/templates 33 $ cp -p example01.dfb /h/oracle/oradata/orcl/
bash sol oracle ~/product/10r2/assistants/dbca/templates 33 $

I tried a simple command line:

imp transport_tablespace=y
file=example.dmpdatafiles=/h/oracle/oradata/orcl/example01.dfb tablespaces=EXAMPLE
tts_owners=HR,IX,OE,PM,SH

Here is the error I see:

Import: Release 10.2.0.2.0 - Production on Sat Sep 15 03:18:40 2007

Username: sys as sysdba
Password:

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options

Export file created by EXPORT:V10.02.01 via conventional path About to import transportable tablespace(s) metadata... import done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set export client uses US7ASCII character set (possible charset conversion) . importing SYS's objects into SYS
. importing SYS's objects into SYS
IMP-00017: following statement failed with ORACLE error 19721: "BEGIN sys.dbms_plugts.checkDatafile
(NULL,3922789679,5,12800,6,5,4194302,8"
"0,531999,547751,1,20971522,NULL,NULL,NULL); END;" IMP-00003: ORACLE error 19721 encountered

lookee here ORA-19721: Cannot find datafile with absolute file number 5 in tablespace EXAMPLE
lookee here

ORA-06512: at "SYS.DBMS_PLUGTS", line 2065
ORA-06512: at line 1
IMP-00000: Import terminated unsuccessfully
bash sol oracle ~/product/10r2/assistants/dbca/templates 34 $

bash sol oracle ~/product/10r2/assistants/dbca/templates 34 $ bash sol oracle ~/product/10r2/assistants/dbca/templates 34 $

Is imp expecting me to pre-create an empty database file before I run the import?

I've looked a bit at the docs. I see no evidence I need to do this.

Also I tried impdp.

It tells me

ORA-39143: dump file "/h/oracle/product/10r2/rdbms/log/example.dmp" may be an original export dump file

So, I need to use imp.

Here is what my database files currently look like:

03:23:06 SQL> select file_id,file_name from dba_data_files;

FILE_ID

FILE_NAME

4
/h/oracle/oradata/orcl/users01.dbf

3
/h/oracle/oradata/orcl/sysaux01.dbf

2
/h/oracle/oradata/orcl/undotbs01.dbf

1
/h/oracle/oradata/orcl/system01.dbf

03:23:35 SQL> Thoughts anyone?

Do I need to run some kind of data file creation statement before I run the import?

-Owen

--
http://www.freelists.org/webpage/oracle-l

Received on Sat Sep 15 2007 - 04:37:36 CDT