No question at this time
DBA Top 10
1 M. Cadot 6500
2 B. Vroman 2700
3 J. PĂ©ran 1600
4 P. Tsongayinwe 1500
5 P. Wisse 1200
6 A. Kavsek 1100
7 D. Walgude 400
7 J. Schnackenberg 400
9 J. Alcroft 200
10 A. Hudspith 100
10 D. Johnson 100
10 B. B 100
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48695
Total active users1323
Act. users last 24h3
Act. users last hour0
Registered user hits last week79
Registered user hits last month345
Comment details
Date 15-OCT-14
Type Suggestion
User Emmanuel Chanteloup
Message Here is the script for a clean uninstall :

set head off
set term off
set echo off
set linesize 133
set feedback off
spool remove_plato.sql
select 'drop package ' || owner || '.' || object_name || ' ; ' from dba_objects where object_name like'PLATO%' and object_type='PACKAGE';
select 'drop table ' || owner || '.' || object_name || ' ; ' from dba_objects where object_name like'PLATO$GDP%' and object_type='TABLE';
select 'drop view ' || owner || '.' || object_name || ' ; ' from dba_objects where object_name like'PLATO$GDP%' and object_type='VIEW';
spool off
@remove_plato
set head on
set term on
set echo on
set feedback on
select object_name from dba_objects where object_name like'%PLATO%';
________________________________________
Regards,

Emmanuel