Re: Importing database with LONG colum

From: Your Name <your_login_at_clear.net.nz>
Date: Tue, 20 Apr 1999 10:40:23 GMT
Message-ID: <01be8b1a$c15d99a0$66f1a7cb@bert>

With a database of this size you should be using online database backups instead of an export. An online backup would take much less time with the only constraint being your backup device. The recovery would also only take a few hours depending on your tape device.

Just a note regarding oracle import it does NOT create a table, a index and then load the data. The index is created sfter the data is loaded to minimize IO.

Cheers
Brendon Received on Tue Apr 20 1999 - 05:40:23 CDT