Re: "Original" IMP transportable tablespace. IMP wants a datafile?
- From: "Owen Smith" <owensmith99@xxxxxxxxx>
- To: "David Sharples" <davidsharples@xxxxxxxxx>
- Date: Sat, 15 Sep 2007 11:38:40 -0700
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@xxxxxxxxx> 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@xxxxxxxxx> wrote:
> >
> > Hello Oracle People,
> >
> > I'm trying to figure out how to import a transportable tablespace I found.
> >
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
