Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
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?
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.
