Home » RDBMS Server » Server Administration » Datafiles in oracle 9
Datafiles in oracle 9 [message #229505] Mon, 09 April 2007 00:58 Go to next message
dirish
Messages: 205
Registered: November 2006
Senior Member
Hi Friends,

can you tell me the maximum size of a datafile in oracle 9i?


Thank you,

Dirish
Re: Datafiles in oracle 9 [message #229513 is a reply to message #229505] Mon, 09 April 2007 01:21 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
Unlimited Smile
can you tell me the maximum size of a datafile in oracle 9i?

It is limited according DISK SPACE.
Regards
Taj

[Updated on: Mon, 09 April 2007 01:36]

Report message to a moderator

Re: Datafiles in oracle [message #229522 is a reply to message #229513] Mon, 09 April 2007 01:34 Go to previous messageGo to next message
dirish
Messages: 205
Registered: November 2006
Senior Member
Thx Sir,

also can you tell me the sizes for oracle 7.3.4.0.0, oracle 10g?


Thank you,

Dirish
Re: Datafiles in oracle [message #229524 is a reply to message #229522] Mon, 09 April 2007 01:37 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
also can you tell me the sizes for oracle 7.3.4.0.0, oracle 10g?

Cann't understand please explain more ...
and what is your exact requirement please tell us for help you better.

Regards
Taj
Re: Datafiles in oracle [message #229530 is a reply to message #229524] Mon, 09 April 2007 01:44 Go to previous messageGo to next message
dirish
Messages: 205
Registered: November 2006
Senior Member
Sir,

I also want to know the maximum size of the datafiles in oracle 7.3.4 and 10g?


Thank you,

Dirish
Re: Datafiles in oracle [message #229535 is a reply to message #229524] Mon, 09 April 2007 01:49 Go to previous messageGo to next message
kmkumar24
Messages: 69
Registered: January 2007
Location: Singapore
Member
Hi Dirish,

I hope you are looking for the size to fix for the datafile.
You will not simply fix the size of the datafile.
Kindly ensure if there is more data's coming to any particular datafile. Then you resize that datafile to the maximum size.

In production fix a size and set to autoextent.It will be high risk to take a chance.



Re: Datafiles in oracle [message #229536 is a reply to message #229530] Mon, 09 April 2007 01:51 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>datafiles in oracle 7.3.4 and 10g?
Whatever the version may be, if the OS is 32 bit, then the datafile cannot grow over than 2gb.
9i and above on 64 bit OS will even support terabyte sized datafiles (through bigtablespace option)
Re: Datafiles in oracle [message #229537 is a reply to message #229535] Mon, 09 April 2007 01:52 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>In production fix a size and set to autoextent.It will be high risk to take a chance.
What is the risk here?
How will it get fixed?
Re: Datafiles in oracle 9 [message #229538 is a reply to message #229505] Mon, 09 April 2007 01:52 Go to previous messageGo to next message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

It is 2097152 blocks.

Regards
Michel
Re: Datafiles in oracle 9 [message #229539 is a reply to message #229538] Mon, 09 April 2007 01:56 Go to previous messageGo to next message
kmkumar24
Messages: 69
Registered: January 2007
Location: Singapore
Member
Hi Mahesh,

What is the risk here?
How will it get fixed?

I said that we cant take a chance for risk in the Production Database. It will always prevention is better than cure.
Re: Datafiles in oracle [message #229544 is a reply to message #229536] Mon, 09 April 2007 02:05 Go to previous messageGo to next message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Mahesh,

bigfile tablespace was introduced in 10g not 9i.

Regards
Michel
Re: Datafiles in oracle 9 [message #229551 is a reply to message #229539] Mon, 09 April 2007 02:11 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Michel, yes. Typo!
Re: Datafiles in oracle 9 [message #229557 is a reply to message #229539] Mon, 09 April 2007 02:16 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>It will always prevention is better than cure.
That is what i was asking?
Prevent what with what? Smile
If you mean auto-extend on it is not always a cure. Could become a pain infact.
http://www.orafaq.com/forum/m/182620/42800/?srch=autoextend+on#msg_182620
Previous Topic: Oracle 10g Installation Doubt
Next Topic: Rename table
Goto Forum:
  


Current Time: Wed Dec 07 10:25:23 CST 2016

Total time taken to generate the page: 0.13981 seconds