| |

VerySource

 Forgot password?
 Register
Search
View: 24|Reply: 3

anxious! Advice: how to delete the database

[Copy link]

1

Threads

2

Posts

3

Credits

Newbie

Rank: 1

Credits
3

 China

Post time: 2020-2-2 15:20:01
| Show all posts |Read mode
After I created an expert / adon account, I used imp to import the backup directly. Now I want to delete the imported database. What can I do?
Reply

Use magic Report

0

Threads

66

Posts

45

Credits

Newbie

Rank: 1

Credits
45

 China

Post time: 2020-3-24 01:45:02
| Show all posts
Batch processing
select 'drop' || owner || '.' || object_name || 'cascade;' from dba_objects;

Just execute the batch script
Reply

Use magic Report

1

Threads

2

Posts

3

Credits

Newbie

Rank: 1

Credits
3

 China

 Author| Post time: 2020-5-14 00:30:01
| Show all posts
Checked on Baidu:
connect internal;
drop user user_name cascade;
Reply

Use magic Report

0

Threads

66

Posts

45

Credits

Newbie

Rank: 1

Credits
45

 China

Post time: 2020-5-15 08:45:01
| Show all posts
Also, the same
Reply

Use magic Report

You have to log in before you can reply Login | Register

Points Rules

Contact us|Archive|Mobile|CopyRight © 2008-2020|verysource.com ( 京ICP备17048824号-1 )

Quick Reply To Top Return to the list