Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

How do you solve oracle archive struck?

1913


Is system user sap basis consultant and dialogue user other user like fico, hr, mm user?

1520


When I check transaction sm37 and I want to see the spool I get a message that says "no list available." Why is this?

1446


how can i decleare select-options in module pool table control?

3591


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

1847


IN FUNCTIONAL MODULE SD WE UNFORTUNETLY DELETE OUR ONE ITEM CATEGORY "TAN" FOR THAT WE WANT RECOVER IT WHAT ARE THE PROCEDURES. IS THERE ANY PROCEDURES LIKE RECYCLEBIN. TELL US DETAIL PROCEDURES STEP BY STEP PLEASE

2030


i want my company code and controlling area defaut as 'ABC" through out SAP what to do ? and my plantcode also default to some value

2074


What are the key responsibilities of sap basis administrator?

1083


can u explain step by step procedure of DB REFRESH..Ravi

3743


What are the regular activities u do in solution manager and how

2276


What are the pre requisite for the SAP Installation?

2057


what is the use of psapundo tablespace? what is the error ora -01555 represents.how can u prevent this error?

12118


What is the information derived from OSS notes?

7142


can we give one check for all vendors in automatic payment run? how?

2163


How to transport objects from Production to Development?

2170