Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: "Original" IMP transportable tablespace. IMP wants a datafile?
Did I ...
put the tbs in R/O mode before copying?
I assume it was.
The tbs was created by Oracle.
If you have a copy of 10gR2,
you will find both the datafile and .dmp file here:
$ORACLE_HOME/assistants/dbca/templates/
I did try this:
tts_owners=(HR,IX,OE,PM,SH)
Result:
ORA-19721: Cannot find datafile with absolute file number 5 in
tablespace EXAMPLE
I'm getting some good clues here. Keep them coming!
Thanks,
-Owen
On 9/15/07, Ghassan Salem <salem.ghassan_at_gmail.com> wrote:
> 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 - 18:41:42 CDT