DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=beta;
        h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
        b=gfNuJXPuMpwRO7jZQ0ld6XZidRxOSX2W0diYDdhUopigUeduySFzhfeRHqD19HB+RRYc6P/W/tmQt79o85iCXXIU3gGrWP+2jBp2waPnun/+GXMobmo+2Vf+rIPtMwA7X6Fpq5ZJwW3X3C70fpIfXAozwHizIZ49UHn15IX6NfE=
Message-ID: <b447e8230709152251q24b3f8eeuf9d058885b7df617@mail.gmail.com>
Date: Sat, 15 Sep 2007 22:51:14 -0700
From: "Owen Smith" <owensmith99@gmail.com>
To: "Ghassan Salem" <salem.ghassan@gmail.com>
Subject: Re: "Original" IMP transportable tablespace. IMP wants a datafile?
Cc: "David Sharples" <davidsharples@gmail.com>, Oracle-L@freelists.org
In-Reply-To: <b447e8230709151641s172db605g7980241b9f28ee8d@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Disposition: inline
References: <b447e8230709150237h9939920t33efbd044e0ad3ba@mail.gmail.com>
	 <be592d550709150402w512e3c88i921f4536f5bf8729@mail.gmail.com>
	 <b447e8230709151138k561bb54ub63ab5ab736d6374@mail.gmail.com>
	 <411d50f60709151505g1e889393ub1cc4497966edd95@mail.gmail.com>
	 <b447e8230709151641s172db605g7980241b9f28ee8d@mail.gmail.com>
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-to: owensmith99@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@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@gmail.com> wrote:
> > Owen,
> > did you put the tbs in R/O mode before copying?
> > rgds
> >
> > On 9/15/07, Owen Smith <owensmith99@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@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@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