Ahh, A favorite activity of mine, dumping the db to load elsewhere.
The following contains instructions to export Oracle 8i Database, and the flags indicated on the interactive export routine.
To run the file.
1.) Go to the dos prompt on the db server
2.) Type Exp username/password@instancename
The array fetch buffer size is 4096.
The file should export the data into a good location ie.D:\Exports\backup.dmp
You should select a full export which exports everything in the database, the other two options are owner, which exports the data that this user owns, and tables which exports the data in the specified table.
You should say yes to exporting the table data.
You should all the compressing of extents.
Subscribe and Share!
Did you enjoy this article? Your feedback is very important! I'd like to invite you to keep up to date with the latest posts from Anticlue. We offer several venues. If you have some questions, help can be found here.- Become a Facebook Fan
- Subscribe to Anticlue
- Follow me on Twitter
- Add to Technorati Favorites
- Digg this post
0 Comments to “Dumping Oracle 8i”
Please share your thoughts and suggestions
-
Receive Our eNewsletter
The latest Project Management and Healthcare IT practices
-
About Me
Welcome to the Healthcare IT Project Management Blog of Elyse Nielsen. This is the place where I share the ideas I have learned, the things I’d like to remember, and my thoughts for a brighter future. Find out more.
Subscribe to Our Tips
This weblog is licensed under a Creative Commons License.