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

From: Owen Smith <owensmith99_at_gmail.com>
Date: Sat, 15 Sep 2007 11:38:40 -0700
Message-ID: <b447e8230709151138k561bb54ub63ab5ab736d6374@mail.gmail.com>

David,
Thanks for checking my work.

datafiles is a valid keyword. I do have "datafiles" in my command line.

Unfortunately, datafile is not a valid keyword:

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

transport_tablespace=y file=example.dmp
datafile=/h/oracle/oradata/orcl/example01.dfb tablespaces=EXAMPLE tts_owners=HR,IX,OE,PM,SH
LRM-00101: unknown parameter name 'datafile'

IMP-00022: failed to process parameters, type 'IMP HELP=Y' for help IMP-00000: Import terminated unsuccessfully bash sol oracle ~/product/10r2/assistants/dbca/templates 38 $ bash sol oracle ~/product/10r2/assistants/dbca/templates 38 $

I checked the link you give at oracle-base.

My command line patterns with the command line there.

Unfortunately, the demo there is for 9i. My DB is 10gR2.

Help anyone?

-Owen

On 9/15/07, David Sharples <davidsharples_at_gmail.com> wrote:
> you missed out the datafile keyword in the import command
>
> http://www.oracle-base.com/articles/9i/TransportableTablespaces9i.php
>
>
> On 15/09/2007, Owen Smith <owensmith99_at_gmail.com> wrote:
> >
> > Hello Oracle People,
> >
> > I'm trying to figure out how to import a transportable tablespace I found.
> >
>

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

Received on Sat Sep 15 2007 - 13:38:40 CDT