Home » RDBMS Server » Server Administration » Maximum Tablespaces
Maximum Tablespaces [message #207639] Wed, 06 December 2006 06:43 Go to next message
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.

Re: Maximum Tablespaces [message #207640 is a reply to message #207639] Wed, 06 December 2006 06:45 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Max # of tablespaces is 64k.
Re: Maximum Tablespaces [message #207641 is a reply to message #207639] Wed, 06 December 2006 06:56 Go to previous messageGo to next message
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
Re: Maximum Tablespaces [message #207644 is a reply to message #207639] Wed, 06 December 2006 07:05 Go to previous messageGo to next message
Brayan
Messages: 315
Registered: June 2002
Senior Member
Thanks Very much

Ronald.
Re: Maximum Tablespaces [message #207646 is a reply to message #207641] Wed, 06 December 2006 07:14 Go to previous messageGo to next message
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 Go to previous message
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
Previous Topic: exact copy
Next Topic: Where can I download Oracle 8.0.6?
Goto Forum:
  


Current Time: Tue Dec 06 08:51:59 CST 2016

Total time taken to generate the page: 0.11076 seconds