Link to home
Start Free TrialLog in
Avatar of dedean01
dedean01Flag for United States of America

asked on

Exp/imp utility

I did an export of a user schema and then did an import to another schema, all of the rows transfered over but some of the data in the rows where not consistant .  I used consistant=y while doing the export.  I was wondering if the consistant=y only work when do a full export of the database by the user system.

my exp parfile looked like this
userid=payrole/partool1
log=export_parole.log
file=export_parole.dmp
buffer=400000
rows=y
grants=y
direct=y
consistent=y
statistics=none


my imp parfile looks like this
userid=dev_parole/devpartool1
file=export_parole.dmp
log=imp_from_parole.log
buffer=400000
fromuser=parole
touser=dev_parole
ignore=y
gransts=y
indexes=y
commit=y
Avatar of Jankovsky
Jankovsky
Flag of Czechia image

Of course,
consistent=Y means, all the data will be exported in the state representing the same point of time.

I think it solves your problem.

Pay attention:
CONSISTENT=y is unsupported for exports that are performed when you are connected as user SYS or you are using AS SYSDBA, or both.

Avatar of dedean01

ASKER

I used consistent =y, but the data was missing key information when I imported the data into the other schema.  I thought that I read some where that the parameter consistent=y will only work with a full export of the database by the user "system", is there any validity to that.  
ASKER CERTIFIED SOLUTION
Avatar of Jankovsky
Jankovsky
Flag of Czechia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thank you I took the direct=y out and the data transfer was a successful

thanks