Home » RDBMS Server » Server Utilities » Problem with Export
Problem with Export [message #72805] Tue, 28 October 2003 04:37 Go to next message
shesha
Messages: 24
Registered: August 2003
Junior Member
Hi,

I have a problem while doing the Export.
I have around 1000 Tables in my database, out of which one table is having around 10000 rows, The data in the table is not important but I don't want to delete/truncate/drop the table. Because of this the export is taking long time. I don't want this table to be included in my Export activity.
Is there any option to do this?
Any solution on this will be very much helpfull.

Thanks In advance
Shesha

Report message to a moderator

Re: Problem with Export [message #72810 is a reply to message #72805] Wed, 29 October 2003 16:57 Go to previous messageGo to next message
Thiru
Messages: 1089
Registered: May 2002
Senior Member
This might help you. Just exclude the table in the select statement..

Report message to a moderator

Re: Problem with Export [message #72813 is a reply to message #72810] Wed, 29 October 2003 21:03 Go to previous messageGo to next message
shesha
Messages: 24
Registered: August 2003
Junior Member
Thanks Thiru.

Is there any way to do the same in Windows systems?

Thanks

Report message to a moderator

Re: Problem with Export [message #72817 is a reply to message #72813] Thu, 30 October 2003 09:49 Go to previous message
Thiru
Messages: 1089
Registered: May 2002
Senior Member
I am not too sure about native windows, but I believe you can do the same thing with Windows perl.

-Thiru

Report message to a moderator

Previous Topic: Tablespace size growth
Next Topic: migrate from Oracle 7.3.4 to Oracle 9.2
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 24 21:11:52 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.