Tag Info

New answers tagged

0

Use a query to generate a drop type script [in SQL Plus]: set lines 132 set head off set pages 0 spool drop_types.sql select 'drop type '||type_name||';' from user_types; spool off Then execute the script in SQL Plus: @drop_types.sql


1

You only bypass the listener when you connect as sysdba*. Ordinary connections through SQLPlus still use the listener. As for how it does it, there is a special mechanism for this kind of connection, which allows a database to be administered without a working listener. I do not believe that the workings of this mechanism are published by Oracle. They want ...



Top 50 recent answers are included