exp xxx/xxx full=y file=dd.dmp
- Can I use the following command to import into an Oracle 10g R2 database?
imp xxx/xxx full=y ignore=y rows=y
- What will happen to my sys and system objects? Will they have the 8i objects?
You can use the import command you give in step 1 above. However, use the 10g imp executable for this operation. I would also add the "log=imp.log" parameter so that the output is spooled to a log to help you resolve any errors.
You will probably receive some error messages about various SYS and SYSTEM objects that already exist. You can safely ignore these messages. When performing full imports, I ignore the messages for SYS and SYSTEM.
Dig Deeper on Oracle database backup and recovery
Related Q&A from Brian Peasland
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs. Continue Reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command. Continue Reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. Continue Reading