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

From: <owensmith99_at_gmail.com>
Date: Sun, 16 Sep 2007 06:52:11 -0000
Message-ID: <1189925531.114267.70720@d55g2000hsg.googlegroups.com>

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 Received on Sun Sep 16 2007 - 01:52:11 CDT