Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Purging database question
Deepak,
Didn't really understand your question. Why do you need a tool to purge
the data?
Sounds like SQLPlus would work. Purge database a, don't purge database b.
Unless maybe you mean a tool to keep the dbs in sync, like Oracle
Replication.
You can use that, and you write procedures to do the purge, and make sure
that
those aren't replicated. I did something similar for a client and it was
pretty
complicated, (and it won't be supported by Oracle,) so make sure you want
to
go there. Then, go get a consultant.
hth,
Yosi
sharmakdeep_at_yahoo.com wrote:
> We have database A, which needs to be periodically
> purged. But, at the same time we require to have
> another database B which contains all records of A
> (even the ones purged). Thus, database B should have
> everything (ever growing). Can anyone suggest a method
> or tool to achieve this ?
>
> -- Deepak Sharma
>
> =====
> Oracle DBA,
> Minneapolis, MN
> USA
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Calendar - Get organized for the holidays!
> http://calendar.yahoo.com/
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Deepak Sharma
> INET: sharmakdeep_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).
-- Thanks, Yosi --------------------------------------------------------- Yosi Greenfield Database ArchitectReceived on Tue Nov 14 2000 - 09:36:18 CST
![]() |
![]() |