Home » RDBMS Server » Server Administration » Removing all objects in Oracle 8 on UNIX platform
Removing all objects in Oracle 8 on UNIX platform [message #64169] Sat, 25 December 2004 02:44 Go to next message
thomasho
Messages: 5
Registered: December 2004
Junior Member
Hi all

I am currently using Oracle 8 in UNIX but I have to clear all objects such as tables, index, user schema, procedures and so on. And then retaining original instance to create new objects.

Is there any concern to remove all stuff in simple and safe way? Also, any additional thing need to be done under UNIX environment?

Or any sample script can help complete this action?

Thanks for your attention

Regards
Thomas

Report message to a moderator

Re: Removing all objects in Oracle 8 on UNIX platform [message #64173 is a reply to message #64169] Mon, 27 December 2004 04:03 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
when you remove the SCHEMA, all associated objects are automatically dropped.

-- this will do it.
-- DO NOT try to remove SYS / SYSTEM users.
sql > drop user userName cascade;

Report message to a moderator

Previous Topic: Tracing active users
Next Topic: Mirror Redo log file status is showing Invalid
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jan 09 22:59:27 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.