Home » RDBMS Server » Server Utilities » export problem
export problem [message #69416] Fri, 28 December 2001 21:25 Go to next message
Sachin
Messages: 52
Registered: May 2001
Member
i wants to take full export of system but i wants to exclude one table of one on the user

----------------------------------------------------------------------
Re: export problem [message #69417 is a reply to message #69416] Mon, 31 December 2001 20:58 Go to previous message
AV.NACHIAPPAN
Messages: 9
Registered: December 2001
Junior Member
Hai Happy New Year 2002

Regarding your Question:

Exports can be done on the following modes

full mode, user mode and tables

in full mode we do not have an option to
exclude a particular table of a particular user

in user mode also we have to export the full
user the objects owned by the user will be exported.

whereas in table mode we can take whatever table
we want of a particular user.

In your case it is better to drop the table
from the system and you can export the full
database. If the table is needed in the current
machine take a full system export. While importing import all the tables in the destination
machine. After importing all the tables in the
destination drop the table that you do not want.

I hope this is the way. If there is any other
better way please inform me also.

Thanks and Regards

----------------------------------------------------------------------
Previous Topic: Location of init.ora file
Next Topic: Linesize
Goto Forum:
  


Current Time: Thu Mar 28 18:30:22 CDT 2024