Oracle Magazine, Nov/Dec 2017
Database Application Developer and DBA BEYOND SQL 101 Enter password Connected SQL create table test_ me id number name varchar2 10 ORACLE MAGAZINE NOVEMBER DECEMBER 2017 97 Table created SQL insert into test_ me id name values 1 Try it 1 row created SQL commit Commit complete SQL select from test_ me ID NAME 1 Try it Listing 8 outlines how a user can be altered by a change in its quota and password Note how the act of changing the quota to zero kilobytes enables the user to create a table in the USERS tablespace but results in an error when the user tries to insert data into the table A user can create a table in its default tablespace even when it has no assigned quota because by default Oracle Database does not look to reduce quota usage for the user until a table segment has been created
You must have JavaScript enabled to view digital editions.