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

From: <owensmith99_at_gmail.com>
Date: Sun, 16 Sep 2007 05:53:18 -0000
Message-ID: <1189921998.506278.182310@d55g2000hsg.googlegroups.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 Received on Sun Sep 16 2007 - 00:53:18 CDT