Re: Export/Import ?

Hi !

On UNIX this is the way to do it

Create a parameter file as given below. You may want to add other import options to this script.
Do the import under system/manager( FROMUSER ). Find out about these option by entering: imp help = y.

If the tables are already present in the user's schema(TOUSER) then you may need to truncate the tables otherwise you will duplicate the records, depends on the unique/non-unique index.

First play with the script below. Check table1, table2 etc. in the user's schema.

Then to import all tables delete the tables=( ...,...) clause from the parameter file and inport again.

imp parfile=import_tables_parfile2.txt

Contents of the import_tables_parfile2.txt is given below. You could use usersid = system/manager below.

userid  = /
commit  =y
file    =/r1/export/xyz.dmp
fromuser=system/manager
touser	= ops$abc
ignore  =y
log     =$HOME/log/importing.log
tables  =(
	   table1,
	   table2	
            )

That should do it !!!

Oracleguru
www.oracleguru.net
oracleguru_at_mailcity.com

Sanjay Hans <sanhans_at_mbox5.singnet.com.sg> wrote in article <01bdd5b7$eeca2ac0$b6c915a5_at_oempre-install>...
> Is it possible, to IMPORT a specific user's tables (everything) from a
> DMP file containing the FULL database backup taken using EXPORT
> system/manager.
> If so, what is the procedure.
>
> Thanks in advance.
>
Received on Tue Sep 01 1998 - 10:15:26 CDT