Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: "Original" IMP transportable tablespace. IMP wants a datafile?

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

From: Owen Smith <owensmith99_at_gmail.com>
Date: Sat, 15 Sep 2007 22:51:14 -0700
Message-ID: <b447e8230709152251q24b3f8eeuf9d058885b7df617@mail.gmail.com>


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
Received on Sun Sep 16 2007 - 00:51:14 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US