[QUOTE][i]Originally posted by oradbadmin [/i]
[B]You cold take a cold full backup of your Oracle 7.3 DB and then porting it to Oracle 8.0.
Paying attention to configuration, it should work fine [/B][/QUOTE]
No, I don't think so. You can't change platforms using a cold backup.
Export/import is your only method.
1. Setup new database with correct datafile sizes, users, groups, etc.
2. export old database with full=y
3. ftp dmp file in binary mode to new box
You're RIGHT.I didn't read paying attention to the topic and I didn't see that there was a platform change.
Of course the export is the only way to migrate the DB in this case.
Sorry for miss uderstanding.
Yes, a 7.x -> 8.x import will work with little difficulty. If you are importing the whole database, you will want to read up on the parameters of import/export.
Parameters you might want to think about using with export:
(If you are exp/imp the same version of oracle, DIRECT=Y is _USUALLY_ a good thing. I wouldn't take chances with a version upgrade though)
Parameters you might want to think about using with imp:
BUFFER= (depends on your physical memory)
When u do this with full database export u need not create the users in new database.full database export/import will take care of that.just make sure that tablespaces are named exactly the same as in 7.x db.