| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Help needed
Just, when it comes to it (at the end of the year), create new tablespace:
CREATE TABLESPACE YEAR_2003_TS DATAFILE
'<%ora_home%>\<Oradata>\YEAR_2003.ora' SIZE 2000064K REUSE
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 20M ONLINE;
specifying your own names and locations,
and then add partition, using new tablespace as storage parameter:
ALTER TABLE <your_table> ADD PARTITION YEAR_2003
VALUES LESS THAN (to_date('2004', 'yyyy'))
TABLESPACE YEAR_2003_TS;
Igor Neyman, OCP DBA
ineyman_at_perceptron.com
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" <ineyman_at_perceptron.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Re: Help needed
>Date: Wed, 03 Apr 2002 06:53:33 -0800
>
>Put each partition into separate tablespace.
>
>Igor Neyman, OCP DBA
>ineyman_at_perceptron.com
>
>----- Original Message -----
>To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
>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: rakesh_banerjee_at_hotmail.com
>
>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: ListGuru_at_fatcity.com (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: ineyman_at_perceptron.com
>
>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: ListGuru_at_fatcity.com (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: rakesh banerjee INET: rakesh_banerjee_at_hotmail.com 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: ListGuru_at_fatcity.com (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: ineyman_at_perceptron.com 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: ListGuru_at_fatcity.com (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).Received on Wed Apr 03 2002 - 12:06:21 CST
 |
 |