-
Importing multiple schemas.
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
I remember when this place was cool.
-
Hey Hanky-Poo,
How did you know about MY_DOG_FACED_COUSIN_YOLANDA???
Anyway, thanks for the info. I actually was pretty close to the syntax, I just didn't have the commas.
Thanks again...
-
Originally posted by smoothyc
Hey Hanky-Poo,
How did you know about MY_DOG_FACED_COUSIN_YOLANDA???
Thanks again...
She gets around, I should be thanking you.
MH
I remember when this place was cool.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|