dedean01
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/devparto ol1
file=export_parole.dmp
log=imp_from_parole.log
buffer=400000
fromuser=parole
touser=dev_parole
ignore=y
gransts=y
indexes=y
commit=y
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/devparto
file=export_parole.dmp
log=imp_from_parole.log
buffer=400000
fromuser=parole
touser=dev_parole
ignore=y
gransts=y
indexes=y
commit=y
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.
CONSISTENT=y is unsupported for exports that are performed when you are connected as user SYS or you are using AS SYSDBA, or both.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you I took the direct=y out and the data transfer was a successful
thanks
thanks
consistent=Y means, all the data will be exported in the state representing the same point of time.
I think it solves your problem.