Creating oracle database physical files from migrated DB

oracleoracle-11g-r2

I migrated a database from SQL Server to Oracle 11g and there doesn't seem to be any physical files created after migration.

The client requires that they receive a copy of the database so they can clone it wherever they need. How do I create the files from the existing database? I'm from SQL server so it's pretty easy to get the files with a few clicks. Are there any similar feature for oracle 11g? Any alternatives if there aren't?

Best Answer

You should use export/import. On your side do:

expdp system/systempawwdord SCHEMAS=YOURSCHEMA

This will produce a file. Take it manually to you customer using CD, DVD, Pendrive. On customer site do:

impdp system/systempassword SCHEMAS=YOURSCHEMA

If the customer is using a different Oracle version, this is not a problem. You probably need to manually re-create tablespaces before importing the DB and add to the impdp command:

REMAP_TABLESPACES=OLDTBS:NEWTBS

For testing you can also do it on your actual instance, export, drop schema and import.

Related Question