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.
Printable View
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,
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.
Thanks for your input.
dbms_metadata.get_ddl