Re: "Original" IMP transportable tablespace. IMP wants a datafile?
- From: "Owen Smith" <owensmith99@xxxxxxxxx>
- To: "Ghassan Salem" <salem.ghassan@xxxxxxxxx>
- Date: Sat, 15 Sep 2007 22:51:14 -0700
ok,
I think I understand what is going on.
I now doubt that
$ORACLE_HOME/assistants/dbca/templates/example01.dfb
is a copy of a database file.
What is it?
bash sol oracle ~/product/10r2/assistants/dbca/templates 67 $
bash sol oracle ~/product/10r2/assistants/dbca/templates 67 $
bash sol oracle ~/product/10r2/assistants/dbca/templates 67 $
bash sol oracle ~/product/10r2/assistants/dbca/templates 67 $ ls -la
$ORACLE_HOME/assistants/dbca/templates/example01.dfb
-rwxr-xr-x 1 oracle dba 13115392 Jun 27 2006
/h/oracle/product/10r2/assistants/dbca/templates/example01.dfb*
bash sol oracle ~/product/10r2/assistants/dbca/templates 68 $
bash sol oracle ~/product/10r2/assistants/dbca/templates 68 $
bash sol oracle ~/product/10r2/assistants/dbca/templates 68 $
It is probably a binary file which DBCA can convert into a database file
once DBCA knows which characterset lives inside the target database.
The transportable tablespace feature depends on a matching
of charactersets between the transported data file and the target DB.
-Owen
On 9/15/07, Owen Smith <owensmith99@xxxxxxxxx> wrote:
> 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@xxxxxxxxx> wrote:
> > Owen,
> > did you put the tbs in R/O mode before copying?
> > rgds
> >
> > On 9/15/07, Owen Smith <owensmith99@xxxxxxxxx> 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@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
> > >
> > >
> > >
> >
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
