OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Maximum Tablespaces

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

Maximum Tablespaces [message #207639]

Wed, 06 December 2006 06:43

Brayan
Messages: 315
Registered: June 2002

Senior Member

Hi,

Database : 9.2.0.7.0

Is there any limitation on maximum number of tablespaces??

I'm planning for monthwise table partition.

That means in 5 years time I'll have 60 tablesspaces for this table.

Ronald.

Report message to a moderator

Re: Maximum Tablespaces [message #207640 is a reply to message #207639]

Wed, 06 December 2006 06:45

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Max # of tablespaces is 64k.

Report message to a moderator

Re: Maximum Tablespaces [message #207641 is a reply to message #207639]

Wed, 06 December 2006 06:56

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

hi ,
go through below link
http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14237/limits003.htm

Report message to a moderator

Re: Maximum Tablespaces [message #207644 is a reply to message #207639]

Wed, 06 December 2006 07:05

Brayan
Messages: 315
Registered: June 2002

Senior Member

Thanks Very much

Ronald.

Report message to a moderator

Re: Maximum Tablespaces [message #207646 is a reply to message #207641]

Wed, 06 December 2006 07:14

ebrian
Messages: 2794
Registered: April 2006

Senior Member

user52 wrote on Wed, 06 December 2006 07:56

hi ,
go through below link
http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14237/limits003.htm

That link shows the logical structures. As was already stated, it's 64K. Don't know what was wrong w/ that answer?

[Updated on: Wed, 06 December 2006 07:15]

Report message to a moderator

Re: Maximum Tablespaces [message #207682 is a reply to message #207646]

Wed, 06 December 2006 10:23

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

hi ebrian,
i am just give more information about Logical Limit of database.

regards
Taj

Report message to a moderator

Previous Topic:	exact copy
Next Topic:	Where can I download Oracle 8.0.6?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 06:28:47 CDT 2024