OraFAQ Forum: Server Administration » Datafiles in oracle 9

Home » RDBMS Server » Server Administration » Datafiles in oracle 9

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

Datafiles in oracle 9 [message #229505]

Mon, 09 April 2007 00:58

dirish
Messages: 232
Registered: November 2006

Senior Member

Hi Friends,

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

Thank you,

Dirish

Report message to a moderator

Re: Datafiles in oracle 9 [message #229513 is a reply to message #229505]

Mon, 09 April 2007 01:21

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

dirish
Messages: 232
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

Report message to a moderator

Re: Datafiles in oracle [message #229524 is a reply to message #229522]

Mon, 09 April 2007 01:37

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

Report message to a moderator

Re: Datafiles in oracle [message #229530 is a reply to message #229524]

Mon, 09 April 2007 01:44

dirish
Messages: 232
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

Report message to a moderator

Re: Datafiles in oracle [message #229535 is a reply to message #229524]

Mon, 09 April 2007 01:49

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.

Report message to a moderator

Re: Datafiles in oracle [message #229536 is a reply to message #229530]

Mon, 09 April 2007 01:51

Mahesh Rajendran
Messages: 10707
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)

Report message to a moderator

Re: Datafiles in oracle [message #229537 is a reply to message #229535]

Mon, 09 April 2007 01:52

Mahesh Rajendran
Messages: 10707
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?

Report message to a moderator

Re: Datafiles in oracle 9 [message #229538 is a reply to message #229505]

Mon, 09 April 2007 01:52

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

Senior Member
Account Moderator

It is 2097152 blocks.

Regards
Michel

Report message to a moderator

Re: Datafiles in oracle 9 [message #229539 is a reply to message #229538]

Mon, 09 April 2007 01:56

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.

Report message to a moderator

Re: Datafiles in oracle [message #229544 is a reply to message #229536]

Mon, 09 April 2007 02:05

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

Senior Member
Account Moderator

Mahesh,

bigfile tablespace was introduced in 10g not 9i.

Regards
Michel

Report message to a moderator

Re: Datafiles in oracle 9 [message #229551 is a reply to message #229539]

Mon, 09 April 2007 02:11

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Michel, yes. Typo!

Report message to a moderator

Re: Datafiles in oracle 9 [message #229557 is a reply to message #229539]

Mon, 09 April 2007 02:16

Mahesh Rajendran
Messages: 10707
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

Report message to a moderator

Previous Topic:	Oracle 10g Installation Doubt
Next Topic:	Rename table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 00:43:42 CDT 2024