OraFAQ Forum: Server Administration » How to reduce the size of a table in Oracle 8

Home » RDBMS Server » Server Administration » How to reduce the size of a table in Oracle 8 (Oracle 8.0.3)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

How to reduce the size of a table in Oracle 8 [message #567489]

Tue, 02 October 2012 03:29

oraclegac
Messages: 2
Registered: October 2012
Location: Canary Islands

Junior Member

Hi all,

One of our solaris machines is running Oracle 8.0.3

A table reached the 2 Gb size and oracle failed due to the operating system file size limitation.

The information in the table is not relevant and can be deleted, but the table contains a lot of indexes.

I would like to know the best procedure to delete the information and reduce the size of the file.

Thanks for your help

Report message to a moderator

Re: How to reduce the size of a table in Oracle 8 [message #567490 is a reply to message #567489]

Tue, 02 October 2012 03:37

Michel Cadot
Messages: 54129
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

export / drop table / shrink (resize) file / import

Regards
Michel

Report message to a moderator

Re: How to reduce the size of a table in Oracle 8 [message #567492 is a reply to message #567490]

Tue, 02 October 2012 04:00

oraclegac
Messages: 2
Registered: October 2012
Location: Canary Islands

Junior Member

Hi Michel, thanks for your answer.

I do not want the records in the table. Why is it necessary export/import?

By the way, when I execute the drop table command I get this error:

"unique/primary keys in table referenced by foreing keys"

Thanks for your help

Report message to a moderator

Re: How to reduce the size of a table in Oracle 8 [message #567493 is a reply to message #567492]

Tue, 02 October 2012 04:33

Michel Cadot
Messages: 54129
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

So drop with the option "cascade constraints".
If you don't want the data you can truncate the table (after disabling the foreign keys).
Then you can try to resize the files but it may not be possible and so you have to export the objects in the tablespace and drop them before resizing the files and reimporting the objects.

Regards
Michel

Report message to a moderator

Previous Topic:	Database upgrade and XDB
Next Topic:	Modified objects

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 19 12:07:10 CDT 2013

Total time taken to generate the page: 0.10941 seconds