export problem [message #69416] |
Fri, 28 December 2001 21:25 |
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 |
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
----------------------------------------------------------------------
|
|
|