-
Need to Copy Schema to Prod
Hi,
I am running Oracle 10.2.0.3 on Suns 10. I need to copy a schema (not the data) from the development database to the production database. The schema does not exist in production. How can I accomplish this task?.
Thanks,
Lucky.
-
while exporting use CONTENT=METADATA_ONLY option. Before importing pre-create the user in the production database.
Thanks,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
-
You might want to check the tablespaces for all that users objects first, if the tablespaces do not exist in your target environment those objects will fail to import.
The REMAP_TABLESPACE option in datapump works well for this, especially when you have a hundred or so tablespaces.
I remember when this place was cool.
-
Need to Copy Schema to Prod
-
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
|