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

Now I got it figured out.

$ORACLE_HOME/assistants/dbca/templates/example01.dfb

Is a data file backup (.dfb).

It was created by RMAN I suspect.

I wrote the following shell script to get the file restored and the tablespace transported:

#! /bin/sh

. /h/oracle/.orcl

cd $ORACLE_HOME/demo/schema/

sqlplus '/as sysdba' @mkplug.sql s s s s s s s \

 $ORACLE_HOME/assistants/dbca/templates/example.dmp \
 $ORACLE_HOME/assistants/dbca/templates/example01.dfb \
 $ORACLE_BASE/oradata/orcl/example01.dbf \
 $ORACLE_HOME/demo/schema/log

# end

Notice that it calls
$ORACLE_HOME/demo/schema/mkplug.sql

It's a complex SQL script which does many things.

I like the script; it made me happy.

-Owen

On 9/15/07, Owen Smith <owensmith99_at_gmail.com> wrote:
> 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_at_gmail.com> 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_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-l