Home » SQL & PL/SQL » SQL & PL/SQL » Partitions....
Partitions.... [message #21780] Thu, 29 August 2002 07:00 Go to next message
Richard McBride
Messages: 10
Registered: August 2002
Junior Member
What is the concept of partitions?

How do you build partitions?

How do you name partitions?

I have heard that partitions can be "activated" and "deactivated". What exactly is this?

Is there a maximum # of partitions for a table/tablespace/schema?

Thanks

Rich
Re: Partitions.... [message #21824 is a reply to message #21780] Tue, 03 September 2002 07:36 Go to previous message
Mike
Messages: 417
Registered: September 1998
Senior Member
Just have a look a the oracle doc and most of your questions will be answered:

http://doc.oracle.com/cd_a97630/server.920/a96524/c12parti.htm#460853
Previous Topic: Procedure to create a new user and list the new user in a table
Next Topic: storage for number and character fields
Goto Forum:
  


Current Time: Sat Apr 20 10:09:46 CDT 2024