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?

  • @Mat I have a copy of the sql server in my PC and migrated it to oracle 11g which is also from my PC. We usually pass the "default" state of the database to the client so they can install it on both production and test servers easily (using an installer). I can't remotely access the server. Any suggestions? I'm thinking of doing a backup of the database and restore it in the remote oracle DB.
    – Bahamut
    May 21, 2013 at 10:18

1 Answer 1


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:


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

  • @Ste Please provide more specific answers and links to these "techniques". I migrated from sql server using sql developer's migration feature.
    – Bahamut
    May 21, 2013 at 9:49
  • @Bahamut reading also your comments to your question this is my solution:
    – Ste
    May 21, 2013 at 10:35

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.