| Oracle database compression [message #365859] |
Wed, 23 February 2000 04:24  |
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.
|
|
|
|
| Re: Oracle database compression [message #365861 is a reply to message #365859] |
Wed, 23 February 2000 15:58  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
