Rakesh ,
create your tablespaces as required using system managed or LMT's.
I chose LMT and I wanted to control the size of the extents.
example:
CREATE TABLESPACE IDSR_DATA_02
DATAFILE '/data3/lnxdb/idsr02d.dbf' SIZE 1600 M
AUTOEXTEND ON NEXT 20 M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 20 M;
CREATE TABLESPACE IDSR_INDX_93
DATAFILE '/indx1/lnxdb/idsr93i.dbf' SIZE 12 M
AUTOEXTEND ON NEXT 2 M
NOLOGGING
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 2 M;
Then you create the tables for the tablespaces.
Example:
CREATE TABLE GLCIDSR (
SALEDATE DATE,
additional columns.......)
PARTITION BY RANGE(SALEDATE)
(PARTITION IDSRD93 VALUES LESS THAN ('01-01-1994')
TABLESPACE IDSR_DATA_93,
PARTITION IDSRD94 VALUES LESS THAN ('01-01-1995')
TABLESPACE IDSR_DATA_94,........
Then create the indexes for the tables.
Example.
ALTER TABLE glcidsr
ADD CONSTRAINT glcidsr_pk
PRIMARY KEY ( saledate)
USING INDEX
local
(partition idsr93 tablespace idsr_indx_93
storage (initial 1 M next 1 M pctincrease 0),
partition idsr94 tablespace idsr_indx_94
storage (initial 2 M next 2 M pctincrease 0),.......
There is very good documentation available on using these features that
Oracle has developed. Remember that some of the features must be
purchased if used in a business.
ROR mª¿ªm
>>> [EMAIL PROTECTED] 04/03/02 10:33AM >>>
Hi,
Thanks for ur answer. Can u please help me in giving the code about how
to
implement it, i.e. how to write the code specifying the particular
tablespace, because as the new financial year will appear, new
tablespace
will be required. So how it can be managed to put the code in the DDL
script
so that it assigns the tablespace automatically. Waiting for ur reply.
With Regards
Rakesh Banerjee
>From: "Igor Neyman" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: Help needed
>Date: Wed, 03 Apr 2002 06:53:33 -0800
>
>Put each partition into separate tablespace.
>
>Igor Neyman, OCP DBA
>[EMAIL PROTECTED]
>
>----- Original Message -----
>To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
>Sent: Wednesday, April 03, 2002 9:18 AM
>
>
>HELP
>
>Hi,
>
>I am working with Oracle 8i version in our ERP applications. I have
one
>question regarding the backup of Oracle database. In the database I
am
>designing it is required to partition the database as per financial
>year.Almost all the tables will be partitioned accordingly. I want to
know
>WHETHER IT IS POSSIBLE TO TAKE THE BACKUP OF INDIVIDUAL PARTITIONS
(i.e. OF
>THE YEARWISE DATA). IF YES, THEN HOW IT CAN BE DONE. Waiting for your
reply
>at the earliest, as my design will be dependent on your feedback.
>
>With Regards
>Rakesh Banerjee
>
>
>_________________________________________________________________
>Join the world's largest e-mail service with MSN Hotmail.
>http://www.hotmail.com
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: rakesh banerjee
> INET: [EMAIL PROTECTED]
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing
Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Igor Neyman
> INET: [EMAIL PROTECTED]
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing
Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
_________________________________________________________________
Join the worldÆs largest e-mail service with MSN Hotmail.
http://www.hotmail.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: rakesh banerjee
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ron Rogers
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
