Oracle-L: Re: Help needed

From: Naveen Nahata <naveen_nahata_at_yahoo.com>
Date: Wed, 03 Apr 2002 07:03:29 -0800
Message-ID: <F001.00439E28.20020403070329@fatcity.com>

Rakesh,

You have 2 options.

Either create the different partitions on different tablespaces and take backup of selected tablespaces
You can take a logical backup using the export utility by providing a query clause for the table.

HTH,
Naveen
--- rakesh banerjee <rakesh_banerjee_at_hotmail.com> wrote:
> 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).

Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Naveen Nahata
  INET: naveen_nahata_at_yahoo.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 - 09:03:29 CST