Anticlue

Dumping Oracle 8i

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.