rrisal
asked on
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.
Thanks
Thanks
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
"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.
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.