(i) Oracle Learning Notes-table and table spaces

1. Table Space

A database can have more than one table space, and a table space can have more than one table. A tablespace is a physical space to store multiple tables, and you can specify the size and location of the table space.

1.1 Creating Table Space statements

Create ' F:\app\zang\oradata\orcl\ts1.dbf '  onnext  10M maxsize 1024M;

According to the above statement, create a size of 50M in the F:\tablespace directory, increment 10M at a time when the space is low, and limit the table space with a maximum space of 1024M.

1.2 Modifying the User default table space

View User default tablespace can be found in views dba_users right-click to select query data to view

Change the current User default table space

Alter Database default tablespace ts1;

Table Space Renaming

Alter  to Tss1;

Delete Table space

Drop  and Datafiles;

2. Oracle Database tables

This creates a data table using a graphical interface

Add table content after creation is complete

Note: The above steps are operated under administrator privileges, and if you use user rights, the query needs to be accessed using the "User name. Table" format.

For example, administrator privileges:

Select *  from A1 T

User rights:

Select *  from Scott.a2;

3. Oracle Virtual Table Dual table

The Dual table is a virtual table under the SYS user, and provides some arithmetic and date operations.

Select  from dual;

(i) Oracle Learning Notes-table and table spaces