| Export utility of Oracle [message #54821] |
Mon, 09 December 2002 00:39  |
Rupak Basak
Messages: 9
Registered: December 2002
|
Junior Member |
|
|
Hello,
If I want the SYS tables INCEXP, INCFIL. and INCVID to reflect your exports, will all the 3 sentences below accomplish this?
1. exp80 system/manager FULL=Y
2. exp80 system/manager FULL=Y INCTYPE=INCREMENTAL RECORD=Y
3. exp80 system/manager FULL=Y RECORD=Y
I am in doubt with 3. I think 1 & 2 will be the correct choice. 3 is incorrect to me bcoz it does not mention the INCTYPE inspite of mentioning the RECORD.
Could anybody guide me with the corrct soln and the logic behind it?
Regards,
/Rupak
|
|
|
|
| Re: Export utility of Oracle [message #54842 is a reply to message #54821] |
Mon, 09 December 2002 13:11  |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
Since INCTYPE is not setup, it will default to ... ??? NONE - right? Which means no incremental export will be done, which translates to .. ??? Full export. Will the full db export have the "SYS tables INCEXP, INCFIL. and INCVID" as of their state in the export time?? Yes. It will have it.
BTW, teh RECORD=Y option will be irrelevant for option3. It will default to option 1.
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
