Re-Design of Database

[hirani_prashant]

Lets guess that i had taken my whole "Sales" database backup by means of Oracle Export Utility which was in oracle 9i platform.
Now i want that database backup in my oracle 10g platform by means of oracle Import Utility.
I do have to do this changes in my new machine where only oracle 10g and my new OS with necessary all the application installed and there is not any backup is there on my machine.
in that situation wt all are things that i have to consider at the time of Import.

Thanks in Advance

[davey23uk]

getting the import options right would be a good start

also export is not a backup

[hirani_prashant]

Thanks for the help.

ya i know that import is the best option..
but my question is that what all are the things that i have to consider at the time of importing...

At the time of import which care i should have to take so that in future it wont create any problem.......

i hope my question is clear now...


thanks in advance.....

[monto1]

1)Install 10g software.
2create 10g database.
3)import full database-(if directory structures are same of source and target)
if not then..
3a)pre-create all the tablespaces in target as in source database.
then import full with ignore=y.

Note:As said by davey export is not a backup .

Regards