Home » Infrastructure » Unix » Clean up the Oracle database
Clean up the Oracle database [message #324350] Mon, 02 June 2008 02:08 Go to next message
ravindragdm
Messages: 25
Registered: May 2008
Location: Bangalore
Junior Member
Hi

How to View and Clean up the Oracle Database from previous AR System Tables.

Any Advice would be greatly appreciated.

With warm regards

[MERGED by LF]

[Updated on: Mon, 02 June 2008 12:03] by Moderator

Report message to a moderator

Re: Clean up the Oracle Database [message #324353 is a reply to message #324350] Mon, 02 June 2008 02:26 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What are "AR System Tables"?
And what are "previous AR System Tables"? Previous to what?

Regards
Michel
drop tablespace and user [message #324354 is a reply to message #324350] Mon, 02 June 2008 02:29 Go to previous messageGo to next message
ravindragdm
Messages: 25
Registered: May 2008
Location: Bangalore
Junior Member
hi

how to drop the ARSystem(software/tool i installed) database and drop the database user ARAdmin(User i created).

Any advice would be greatly appreciated..
Please do needful

[Updated on: Mon, 02 June 2008 02:30]

Report message to a moderator

Re: drop tablespace and user [message #324357 is a reply to message #324354] Mon, 02 June 2008 02:33 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If it is a tool you installed I suggest you to refer to your installation/user guide or vendor site.

Regards
Michel
Re: Clean up the Oracle Database [message #324365 is a reply to message #324350] Mon, 02 June 2008 03:24 Go to previous messageGo to next message
ravindragdm
Messages: 25
Registered: May 2008
Location: Bangalore
Junior Member
Hi

i installed my package AR System which created some table.
how can i delete trhat in ORACLE database

With warm regards
ravindra

[Updated on: Mon, 02 June 2008 03:24]

Report message to a moderator

Re: drop tablespace and user [message #324367 is a reply to message #324357] Mon, 02 June 2008 03:34 Go to previous messageGo to next message
ravindragdm
Messages: 25
Registered: May 2008
Location: Bangalore
Junior Member
hi

Let me know generally how to delete specific database tables.

with warm regards
Re: Clean up the Oracle Database [message #324373 is a reply to message #324350] Mon, 02 June 2008 03:49 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
drop the tables with the drop command.
What else?
Re: drop tablespace and user [message #324375 is a reply to message #324367] Mon, 02 June 2008 04:09 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
DROP TABLE

Regards
Michel
Re: drop tablespace and user [message #324404 is a reply to message #324367] Mon, 02 June 2008 06:30 Go to previous message
cvs_1984
Messages: 136
Registered: August 2007
Location: Punjab, INDIA
Senior Member

Remove the Table from Database:

DROP TABLE <table_name>;

Remove the User from Database:

DROP USER <username>;


Regards

CVS
Previous Topic: log file creation
Next Topic: Problem: How to schedule and execute the PL/SQL Procedure through shell scripting
Goto Forum:
  


Current Time: Thu Mar 28 13:13:48 CDT 2024