Some simple Oracle Database statements

After using dbca to create a database, create a table. Before creating a table, create a table, and then create a user to use the table space as the user's default table space, finally, log on to the user and create a table. By default, the table created by the user is created in the tablespace just created. The following sqlplus statements:

Create tablespace prl_data
Datafile 'usr/local/oracle10/data/Mo/prldata. dbf'
Size 1024 MB;

 

Create user prolactin identified by prolactin ******
Default tablespace prl_data

 

Grant connect, resource, DBA to prolactin

 

Conn top 5/top 5 ******

 

Create Table testtable (

Id integer primarykey,

User nvarchar2 (20 ),

Age integer

);