You don't have a recycle bin in Oracle < 10g and, in any case, you don't need to purge it manually (it gets purged automatically when space pressure occurs).
In order to reclaim the free space in the tablespace, in Oracle 9i, you need to recreate (move) the table (and rebuild its relative indexes) subject to mass deletions.
You need to take special care if you need to do this in production, because (this is not a complete list):
1. During the move the table will be locked in exclusive mode.
2. Right after the move the indexes on the table will be marked unusable and statements that try to use those indexes will fail (you'll need a maintenance window).
3. Before you begin you'll need to check the definitions of the involved objects - for example if you have compressed indexes you may end up with no compression after the rebuild (i.e. you'll need to include compress in the alter statement too).
4. You could speed up the operations by using parallel degree greater than 1 (only EE), just remember to reset the degree back to their original values.
5. You could rebuild the indexes online (EE only), but you could move the table online only if it's an IOT (Index Organized Table).
6. Remember to re-gather statistics after the move/rebuild operations.
That said, you can, of course, ad some space to the tablespace.
Hello,
i would like to know what is the use of that command
apt-get install --purgeI understand the use of --purge while using with remove parameter, but i don't get it when it's about installing.
Enlight me please ! Thx
---------- Post updated 09-03-16 at 11:35 AM ---------- Previous... (0 Replies)
I have these commands that help me find and delete files over certain days.
How can I build a menu to list the files, and then hit y for yes to delete or no?
find /logs/212/abinitio/prod/mfs/partitions/part0/mfs_12way_001/mfs_12way/sncrpt/main/ -name "*dat" -mtime +1 -exec ls -ltr {} \;
find... (3 Replies)
Hi,
I have to make a script to purge logs in a directory (this script will run automatically every day) and this script has to keep just the 30 last files.
So I want it to count all the files in the directory, find the 30 most recents and delete the others.
I just started shell scripting and... (4 Replies)
Hi, I have a purge directory called /b02/purge which has backed up directories like this
drwxrwxr-x 17 root root 4096 Jan 5 15:33 purge1
drwxrwxr-x 17 root root 4096 Jan 5 16:21 purge.new1
drwxrwxr-x 15 root root 4096 Jan 5 16:21 purge.new2
drwxrwxr-x 17 root root 4096 Jan 12... (3 Replies)
Hi ,
I want to purge 7 days older data from a list of data sorted on date in a log file...
Can anyone provide me with the shell script for the same..
Thanks,
Jaz (1 Reply)
I am installing oracle9i on aix5.3 and an link error appears during the install process.
'Error in invoking target iokdstry of makefile
/export/home/oracle/OraHome/network/lib/ins_nau.mk' happened
I tried to find the way out,and there seems to be one... (2 Replies)
Being new I had my focus in the wrong place and typed in xterm instead of <If you can't guess, good>.
Can I purge xterm so that this word no longer appears using up or down arrows? (1 Reply)