Home » RDBMS Server » Server Administration » Re: ORA-27072 error on solaris(oracle ver 8.0.5.2) & Bug 774252
Re: ORA-27072 error on solaris(oracle ver 8.0.5.2) & Bug 774252 [message #54582] Fri, 22 November 2002 08:33 Go to next message
Niraikalai Vijay
Messages: 9
Registered: November 2002
Junior Member
Thank you for the reply.

Database block size is 8192. Multiplying with that block no. gives exact 2GB value.

I have Oracle 8i.
Do you know whether this bug is fixed in later Oracle versions.

-Nirai

Report message to a moderator

Re: ORA-27072 error on solaris(oracle ver 8.0.5.2) & Bug 774252 [message #54598 is a reply to message #54582] Fri, 22 November 2002 14:03 Go to previous message
Niraikalai Vijay
Messages: 9
Registered: November 2002
Junior Member
You are right... Actually I had resized tablespace size to 11GB by thinking Solaris 2.6 supports 2GB limit.

I had wrongly assumed that tablespace size was 1.1GB counting bytes wrongly.

I have identified the table whose contents have been written beyond 2GB limit.

Is there anyway to get the contents of that table?

Because the of the ODBC tool that I am using, I won't be able to upgrade the OS to 5.8 till I get new version of the tool.

I am able to export all the tables except one which is giving this error.

Any help on this will be greatly appreciated.

Thanks
Niraikalai

Report message to a moderator

Previous Topic: libgen, libclntsh missing libraries in Oracle/lib and /usr/lib - solaris 2.5.1
Next Topic: Connecting
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 04:20:06 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.