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

On Sat, 15 Sep 2007 09:34:01 -0000, "owensmith99_at_gmail.com" <owensmith99_at_gmail.com> wrote:

>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.dmp datafiles=/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
>
>Copyright (c) 1982, 2005, Oracle. All rights reserved.
>
>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

What you need to do is read the *manuals* and trying to *understand* them, instead of posting this simultaneously at cdos and the OTN forums.

Transportable tablespaces are transportable tablespaces are transportable tablespace.
You actually move a tablespace, which consists of *existing* datafiles *containing data*. The export will only contain part of the datadictionary to sync the datadictionary of the target tablespace. Is that in the docs? Sure, that is in the docs? Did you *read* those docs? No, you didn't read them, you only *looked* at them, without even *trying* to make sense of the words.

Next time: PLEASE try to be a bit more industrious, before you start wasting people's time all over the planet.

-- 
Sybrand Bakker
Senior Oracle DBA