Custom Search
www.rocket99.com : Technical Guides
Sybase
Oracle
UNIX
Javascript
Technical Guides
Sybase
Oracle
UNIX
Javascript
Of Interest
Be responsible for your future
Enter the USA legally!
Visa, Green Card, Citizenship, Passport
Consultation Services
Oracle » Administration » DBA »
Drop a table and deallocate space
Oracle 10g has a new feature: a Recycle Bin
-- Drop table, free up space, 10g
drop table TABLE_NAME purge;
purge table TABLE_NAME ;
-- Free up storage, Oracle 10g
alter table TABLE_NAME deallocate unused;
-- empty the recycle bin, Oracle 10g
purge user_recyclebin;
Oracle : Related Topics
Oracle : Administration : Server Manager
Oracle : Administration : O/S Password Authentication
Oracle : Administration : Database Creation
Oracle : Administration : Tablespace Creation
Oracle : Administration : Increasing the size of a tablespace
Oracle : Administration : Rollback segments
Oracle : Administration : Adding a redo log file set
Oracle : Administration : Altering table storage
Oracle : Administration : Backing up data files
Oracle : Administration : Taking tablespaces offline
Oracle : Administration : Creating users
Oracle : Administration : DB Verify
Oracle : Administration : Clearing Log Files
Oracle : Administration : Moving Data Files
Oracle : Administration : Index Management
Oracle : Administration : Creating a Schema
Oracle : Administration : Enabling Archive Logging
Oracle : Administration : Updating statistics for a table or schema
Oracle : Administration : Killing Sessions
Oracle : Administration : Recovering an Instance
Oracle : Administration : Dropping a Tablespace
Oracle : Administration : Restricted Mode
Oracle : Administration : Oracle Issues, Facts You Should Know
Sybase Web Site
Sybase iAnywhere Mobile Web Site
Oracle Enterprise Web Site
Get the latest Rocket99 news and tech tips via
Site Index
About this Guide to Sybase, Oracle, and UNIX
Contact Us
Advertise on this site
Copyright © 2019
Stoltenbar Inc
All Rights Reserved.
