How to delete a table from Database level.

Answer Posted / abhay sequeira

Pl. don't do that. Doing so would put the database at an
inconsitent state.

if your installation is under unix and the db is oraacle,
then login as the database administrator.
1) su - ora<SID>

2) sqlplus "/ as sysdba";

3) drop table <schemaname>.tablename;

You can only drop the table if you own it. There are many
such restrictions imposed so that the user does not
delete / drop any table inadvertently

Is This Answer Correct ?    13 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is GRIR, GRIR effect, why it is imp, How it is analysed, What is expected out GRIR, What is auto write off & Manual GRIR write off?

2649


How you can apply sap notes to sap system?

648


what are the pre-requisites to apply support patch?

634


what is the common storage file for oracle ?

1651


What is Unit Testing in SAP?

772






What are the Parameters need to be set when connecting EP to r/3 system what are they?

1372


Explain what is business kpis ?

633


What is your organization’s security philosophy? What level of security does your data require? How much risk are you willing to assume in each application area?

1500


Example you have 6 sap application servers, I want to monitor all the application servers. How to configure a CCMS?

2790


can anyone tellme java instance startup sequence?

9120


describe how to setup a printer in SAP or where they would look to research why a user/users can not print?

644


what is the difference b/w 4.7EE & ECC5.0?

1957


Where can you find a list of object keys included in a transport?

638


What is the information derived from OSS notes?

6209


What is business kpis ?

573