Home » RDBMS Server » Server Administration » Oracle database compression
- Oracle database compression [message #365859] Wed, 23 February 2000 04:24 Go to next message
Gadi
Messages: 1
Registered: February 2000
Junior Member
I need to know how I can compress my Oracle database or archive parts of it.
I have 8GB of data, and want to reduce it's size.

Report message to a moderator

- Re: Oracle database compression [message #365861 is a reply to message #365859] Wed, 23 February 2000 15:58 Go to previous message
Ales
Messages: 11
Registered: February 1999
Junior Member
Hi,

you have many options... in Oracle8i for example:
- partition your 'big' tables, then export and drop partitions
that you don't need on-line
- use transportable tablespace option to archive particular tablespace
- with new QUERY option in export (8.1.5)utility extract subset
of table then delete rows in that subset
- make your own scripts to dump data to ascii files or use third party
tools such as TOAD.

Ales

Report message to a moderator

Previous Topic: Is there a way to upload data in a text file using SQL?
Next Topic: How to stablish a timeour for a query
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun May 04 05:00:04 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.