OraFAQ Forum: Unix » Clean up the Oracle database

Home » Infrastructure » Unix » Clean up the Oracle database

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Clean up the Oracle database [message #324350]

Mon, 02 June 2008 02:08

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

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

What are "AR System Tables"?
And what are "previous AR System Tables"? Previous to what?

Regards
Michel

Report message to a moderator

drop tablespace and user [message #324354 is a reply to message #324350]

Mon, 02 June 2008 02:29

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

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Clean up the Oracle Database [message #324365 is a reply to message #324350]

Mon, 02 June 2008 03:24

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

ravindragdm
Messages: 25
Registered: May 2008
Location: Bangalore

Junior Member

hi

Let me know generally how to delete specific database tables.

with warm regards

Report message to a moderator

Re: Clean up the Oracle Database [message #324373 is a reply to message #324350]

Mon, 02 June 2008 03:49

varu123
Messages: 754
Registered: October 2007

Senior Member

drop the tables with the drop command.
What else?

Report message to a moderator

Re: drop tablespace and user [message #324375 is a reply to message #324367]

Mon, 02 June 2008 04:09

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

DROP TABLE

Regards
Michel

Report message to a moderator

Re: drop tablespace and user [message #324404 is a reply to message #324367]

Mon, 02 June 2008 06:30

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 03 14:25:29 CST 2024