Oracle Magazine, Nov/Dec 2017
Database Application Developer and DBA BEYOND SQL 101 ORACLE MAGAZINE NOVEMBER DECEMBER 2017 100 OBJECT_ TYPE OBJECT_ NAME TABLE TEST_ AGAIN TABLE TEST_ ME SQL DROP USER beyond_ 101 DROP USER beyond_ 101 ERROR at line 1 ORA 01922 CASCADE must be specified to drop BEYOND_ 101 Listing 10 Use the CASCADE option when dropping a user that owns schema objects SQL connect as sysdba Connected SQL alter session set container bynd Session altered SQL DROP USER beyond_ 101 CASCADE User dropped SQL select object_ type object_ name 2 from dba_ objects 3 where owner BEYOND_ 101
You must have JavaScript enabled to view digital editions.