Oracle 9i db export

Is there a guide on how to export an oracle 9i db. What I am trying to do is export the db from my prod enviroment into my development enviroment. Both of these run oracle 9i and are on windows 2003 server.
Who is Participating?
hamitaConnect With a Mentor Commented:
step 1: take a full export of your prod db
exp system/manager FULL=y FILE=exp_full.dmp LOG=exp_full.log
step 2: truncate all tables
step 3: import to another environment
 imp system/manager FULL=y FILE=exp_full.dmp LOG=imp_full.log IGNORE=y
Here is a link:

One way to accomplish what you are trying to do...

1) take a full export of your production database (as outlined in above link)
2) in development environment, truncate all tables
3) import the export file you took in step one

There are plenty of other steps, but this is a very basic outline.

Also, depending upon your needs, there are a host of other solutions that will work, which if you keep this open long enough, you will get other experts to offer help.
joebednarzConnect With a Mentor Commented:
... step 2) ...truncate all tables IN SCHEMAS RELATED TO YOUR APPLICATION
techjiConnect With a Mentor Commented:
if you need to export/import entire db, you need DBA privileges or atleast exp_full_database/imp_full_database.

if you dont have any of these privileges, start treating your DBA to lunch or starbucks.

You can do it yourself without those privileges, but you will have to do it at user level. And depending on the number of users that belong to the application, it can take hours doing the export/import.

for syntax, just do "exp help=y" or "imp help=y". Help is pretty good.
rrisalAuthor Commented:
"if you dont have any of these privileges, start treating your DBA to lunch or starbucks. " I think i need to do that more...... thanks to all of you.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.