We help IT Professionals succeed at work.

need to backup schema

dba1234
dba1234 asked
on
Hi,
I need to full  backup a schema in 9i with imp. What parameters should I use in the par file

Comment
Watch Question

CERTIFIED EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019
Commented:
At least:

CONSISTENT=Y OWNER=<schema name>

The doc link:
http://download.oracle.com/docs/cd/B10501_01/server.920/a96652/ch01.htm

>>I need to full  backup a schema in 9i with imp

I assumed you meant exp (export)

Author

Commented:
sorry, My mistake . It should be exp

Do I need to use
row=y
index=y
grants=y
CERTIFIED EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019
Commented:
>>Do I need to use

Check the doc link I provided.  Look at the default values for those parameters.
johnsoneSenior Oracle DBA
CERTIFIED EXPERT
Commented:
I would suggest using COMPRESS=N as well.

Explore More ContentExplore courses, solutions, and other research materials related to this topic.