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



