| manage data availability with limited quota [message #351699] |
Thu, 02 October 2008 09:42  |
kowalsky
Messages: 37
Registered: May 2003
|
Member |
|
|
hi all,
I have a question about what would it be the simplest/more efficient way to preserve only a portion of the data in some table but be able to access past data if necessary.
What happens is I have a small quota on a database where I need to manage only one table; the table gets around 4 GB of data at the end of each month and that's using the whole quota, so next month I have to store the current month's data somewhere else and load the next 4 GB into my table. In case someone wants to look at the data from 2 months ago, 3 months ago, I need to be able to make it available within reasonable time.
I guess I have no quota on the file system of the client which is a Win2003 server box.
My initial intent was to use export and import so that at the end of each month I export the current contents of the table and store the file resulted on the file system and use import when the need comes to access whatever past data (after exporting the current contents).
Is there any more elegant solutions? I never worked with transportable tables - is it worth to try that?
Thanks,
kowalsky
|
|
|
|
|
|
|
|
| Re: manage data availability with limited quota [message #351709 is a reply to message #351703] |
Thu, 02 October 2008 11:12  |
kowalsky
Messages: 37
Registered: May 2003
|
Member |
|
|
Thank you all for your advice,
Michel,
just want to confirm, the archiving you mention is not an Oracle utility - it is plain archiving with file system utilities (zip, gzip, etc.)
The second reply from Mahesh apparently points to a compressing done within Oracle ...
Thanks again,
kowalsky
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
