You can drop them, sure. But frankly 1.7 is a small database so why bother? I don't think you will save a lot of time, just make sure you do a full backup so that you have the DDL. You may want to take a full export with
FULL=Y
ROWS=N
This will export all the structure (indexes included) and leave the data behind. It takes about 1 minute to run and is a lot easier to read from than a full .DMP file, just an extra precaution IN ADDITION TO YOUR FULL EXPORT!
How long does the full import take?
Are you using constraints (R.I.) on this box?
It should not be that bad even with indexes and analyzes.
MH
Last edited by Mr.Hanky; 02-03-2003 at 04:15 PM.
I remember when this place was cool.
Reply With Quote