Home » RDBMS Server » Server Administration » Oracle database compression
Oracle database compression [message #365859] Wed, 23 February 2000 04:24 Go to next message
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.
Re: Oracle database compression [message #365861 is a reply to message #365859] Wed, 23 February 2000 15:58 Go to previous message
Messages: 11
Registered: February 1999
Junior Member

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.

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:

Current Time: Mon Jul 15 08:58:20 CDT 2024