Can someone tell me the syntax (if any) to import muliple schemas at the same time? I have three large schemas to import into the same database and I would like to submit just one job.
Thanks for any input/information....
smoothyc...
:-)
Printable View
Can someone tell me the syntax (if any) to import muliple schemas at the same time? I have three large schemas to import into the same database and I would like to submit just one job.
Thanks for any input/information....
smoothyc...
:-)
Use an import parfile and use fromuser touser in the proper order.
Ex..
FROMUSER= YO_MAMA, YO_DADA, YO_DOG_FACED_COUSIN_YOLANDA
TOUSER=YO_MAMA, YO_DADA, YO_DOG_FACED_COUSIN_YOLANDA
Make sure the names are in order in the fromuser/touser otherwise you will import YO_MAMA into YO_DOG_FACED_COUSIN_YOLANDA, know what I mean?
MH
Hey Hanky-Poo,
How did you know about MY_DOG_FACED_COUSIN_YOLANDA???
:D
Anyway, thanks for the info. I actually was pretty close to the syntax, I just didn't have the commas.
Thanks again...
She gets around, I should be thanking you. ;)Quote:
Originally posted by smoothyc
Hey Hanky-Poo,
How did you know about MY_DOG_FACED_COUSIN_YOLANDA???
Thanks again...
MH