•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the Oracle section within the Web Development category of DaniWeb, a massive community of 402,035 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,430 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Views: 2407 | Replies: 4
 |
•
•
Join Date: Mar 2007
Posts: 45
Reputation: 
Rep Power: 0
Solved Threads: 1
Light Poster
deleting the tables 
how to delete all the tables in the a user at a time? 
•
•
Join Date: Feb 2007
Location: London
Posts: 114
Reputation:
Rep Power: 2
Solved Threads: 8
Junior Poster
There is no one command to do this, you could write a PL procedure to do it, or generate the SQL statements from USER_TABLES. Alternately some IDE's provide an easier way.
•
•
Join Date: Apr 2007
Posts: 11
Reputation:
Rep Power: 2
Solved Threads: 1
Newbie Poster
if in yor databse you have only tables then simply can drop user
or u can create one one store procedure to delete all table from your databse
or u can create one one store procedure to delete all table from your databse
•
•
Join Date: Feb 2007
Location: Bangalore,India
Posts: 1,213
Reputation:
Rep Power: 4
Solved Threads: 78
try to write a script for this
or
a better option would be to write a cursor and then drop the tables .
or
a better option would be to write a cursor and then drop the tables .
Share your Knowledge.
•
•
Join Date: Aug 2007
Posts: 6
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
You have two options:
---------------------------------------
1) Create a script
set lines 200;
set pages 10000;
spool c:\DROP_TABLES.txt;
select 'DROP TABLE '||table_name||';'
from all_tables
where owner = 'SCOTT';
-- change the SCOTT to the owner of the tables you need to drop.
spool off;
---------------------------------------
@c:\DROP_TABLES.txt; -- to run the script that we created.
-- repeat this step tell u drop all the tables.
---------------------------------------
2) From the Enterprise Manager , Drop the owner Schema.
Regards.
---------------------------------------
1) Create a script
set lines 200;
set pages 10000;
spool c:\DROP_TABLES.txt;
select 'DROP TABLE '||table_name||';'
from all_tables
where owner = 'SCOTT';
-- change the SCOTT to the owner of the tables you need to drop.
spool off;
---------------------------------------
@c:\DROP_TABLES.txt; -- to run the script that we created.
-- repeat this step tell u drop all the tables.
---------------------------------------
2) From the Enterprise Manager , Drop the owner Schema.
Regards.
|
•
•
•
•
•
•
•
•
DaniWeb Oracle Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
Similar Threads
- Searching for a record in multiple tables (VB.NET)
- Deleting a Row From A DataGrid (VB.NET)
- Delete from multiple tables (MySQL)
- Code not working for deleting recordfrom a file (Visual Basic 4 / 5 / 6)
- IE Cache not deleting a URL (Web Browsers)
Other Threads in the Oracle Forum
- Previous Thread: Urgent HELP ME --- i am new to ORACLE
- Next Thread: Time-based updating
