Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: "Original" IMP transportable tablespace. IMP wants a datafile?
Owen,
did you put the tbs in R/O mode before copying?
rgds
On 9/15/07, Owen Smith <owensmith99_at_gmail.com> wrote:
>
> 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
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Sat Sep 15 2007 - 17:05:14 CDT