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 ...


1

Get all privileges from AAA SELECT DBMS_METADATA.GET_GRANTED_DDL('ROLE_GRANT','AAA') FROM DUAL; SELECT DBMS_METADATA.GET_GRANTED_DDL('SYSTEM_GRANT','AAA') FROM DUAL; SELECT DBMS_METADATA.GET_GRANTED_DDL('OBJECT_GRANT','AAA') FROM DUAL; Change the DDL commands with the user 'BBB' and execute.


1

expdp userid=system directory=DATA_PUMP_DIR dumpfile=AAA.dmp schemas=AAA impdp userid=system directory=DATA_PUMP_DIR dumpfile=AAA.dmp remap_schema=AAA:BBB or make use of dbms_metadata user_ddl.sql



Top 50 recent answers are included