Originally posted by marist89
Oh, and export/import is NOT a valid backup plan for a production database.
Unless you have two 24 x 7 databases running in parallel in NOARCHIVELOG mode on two different machines in two different states, using failover.

Then exporting

a). FULL=Y ROWS=N
b). ESSENTIAL TABLE + ROWS = Y

Sorry, but this is a backup strategy I have implemented for a certan production system.

So, I realise that EXPORT/IMPORT is NOT always the best way. But in some cases, it may be the only strategy viable to a particular application. But granted, in MOST cercumstances a logical backup isn't enough.

Cheers,