How to drop tablespace with datafiles

SQL> drop tablespace [tablespace_name] including contents and datafiles;

Options


Start discussion or add comment to this tip

Details

Tip reference : #185 views : 380	Added on : 02/11/08	Submited by : h8dk97

Send a message	Printer friendly output Display this member's tips (149)


Next >>

	Most viewed tips
	Databases > Oracle > Security : How to unlock Oracle user account
	Databases > Oracle > Performance Tuning : How to enable trace in Oracle
	Databases > Oracle : Kill user session
	Databases > Oracle : Scripts to backup Oracle database on Windows NT

	All categories Databases \| Programming \| Hardware \| Operating Systems \| Networking \| Internet \| ERP / CRM \| Games & Multimedia \| Graphics & Design \| Miscellaneous \| Office Software \| TipLib FAQ