Here's how we do it (this assumes that Oracle is installed and
configured on two separate machines).

Export:
dump_bart.cmd:
exp parfile=exp_bart.prf
exp_bart.prf:
userid=system/*****@cmgt.iecokc.com
file=D:\backup\exp_iec_bart.dmp
compress=y
log=exp_iec_bart.log
consistent=y
statistics=none
owner=iec_bart
direct=y
Import:
load_lisa.cmd:
sqlplus iec_lisa/******@cmgt.iecokc.com @droptable.sql
sqlplus iec_lisa/******@cmgt.iecokc.com
@dropsequence.sql
sqlplus iec_lisa/******@cmgt.iecokc.com
@dropprocedure.sql
sqlplus iec_lisa/******@cmgt.iecokc.com @dropview.sql
sqlplus iec_lisa/******@cmgt.iecokc.com @dropsynonym.sql
imp parfile=imp_lisa.prf
sqlplus system/******@cmgt.iecokc.com @lisa_perms.sql
del deltable.sql
del delseq.sql
del delproc.sql
del delview.sql
del delsyn.sql
del setperms.sql
*.sql:
pseudo-sql: drop (table|sequence|procedures|...) for
the user
imp_lisa.prf:
userid=system/*****@cmgt.iecokc.com
fromuser=iec_bart
touser=iec_lisa
file=exp_iec_prod.dmp
log=imp_iec_lisa.log
ignore=y

--
Jason Lee
Programmer/Analyst


-----Original Message-----
From: BRoussel
[mailto:oracledba-ezmlmshield-x98332616.[Email address protected]
Sent: Wednesday, July 06, 2005 8:55 AM
To: LazyDBA Discussion
Subject: Export - Import


Hi DBAs,

I have to do an export from production database and import into a
test database. What are the steps to perform this activity? It for a
specific owner.

Regards,

Bruno



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page