Home » RDBMS Server » Server Administration » Archive a part of a table.
Archive a part of a table. [message #52841] Fri, 16 August 2002 02:11 Go to next message
Vikram Agarwal
Messages: 2
Registered: August 2002
Junior Member
Hello Gurus,
I need some information regarding a part of a table archiving.

I am trying to archive a part of a table ( for e.g. data which is more than 6 mths old ). The data which is being archived may/maynot be required later on.

What is the best possible way to do this?

Thanks and Regards
Vikram Agarwal

Report message to a moderator

Re: Archive a part of a table. [message #52853 is a reply to message #52841] Fri, 16 August 2002 15:35 Go to previous messageGo to next message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
Partition the table on date range and put each partition in separate tablespace. Then export the archived tablespaces medata as transportable.

Backup the tablespace datafiles on tape and drop them from the database. If you need to restore just copy the datafiles and import the metadata with import.

Hope that helps,

clio_usa
OCP - DBA

Visit our Web site

Report message to a moderator

Re: Archive a part of a table. [message #52899 is a reply to message #52853] Mon, 19 August 2002 21:19 Go to previous message
Vikram Agarwal
Messages: 2
Registered: August 2002
Junior Member
If I have many such tables(of which I intend to take partial backup of for
archival purposes) , can I keep all the partitions of all the tables in a
single tablespace and take a backup of that tablespace ?

Also how to take export of the metadata?

Thanks & Rgds
Vikram

Report message to a moderator

Previous Topic: Error invokinkg target ioracle of makefile ins_rdbms.mk
Next Topic: Tools for database growth/performance monitoring
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Dec 26 10:57:50 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.