Oracle Magazine, Nov/Dec 2017
Database Application Developer and DBA BEYOND SQL 101 for a table A segment is a logical storage structure that stores a schemas object data in this case table data within the schemas default tablespace Users are able to create a table within the USERS tablespace without error because of Oracle Databases default deferred segment creation behavior To learn more about deferred segment creation see the Oracle Database Administrators Guide Listing 8 Alter a user with the ALTER USER data definition language command SQL connect as sysdba Connected SQL alter session set container bynd ORACLE MAGAZINE NOVEMBER DECEMBER 2017 98 Session altered SQL ALTER USER beyond_ 101 quota 0K on users User altered SQL connect beyond_ 101@ bynd Enter password Connected SQL create table test_ again id number Table created SQL insert into test_ again id values 2 insert into test_ again id values 2
You must have JavaScript enabled to view digital editions.