Oracle Command Set

1, after the installation of Oracle, you need to import table data, the operation is as follows:

Connection database: Sqlplus/as sysdba

To create a table space:

Create Tablespace User_data
Logging
DataFile ' D:\oracle\oradata\Oracle9i\user_data.dbf '
Size 50m
Autoextend on
Next 50m maxsize 20480m
Extent management Local;

Create a user and specify a tablespace

Create user username identified by password--note that digital passwords sometimes require double quotes
Default Tablespace user_data
Temporary tablespace user_temp;

Authorization to the User: Grant CONNECT,RESOURCE,DBA to username;

Import data: Sqlplus User/password @ Database service address < File_name.sql

2. Rerun the last SQL statement

sql>/

3. Query the Oracle database how many table space and tablespace status

Select Tablespace_name, Block_size, status, contents, logging from dba_tablespaces;

4. Get the Tablespace file location

SELECT file_id, file_name, tablespace_name, status, bytes from Dba_data_files;

5. Get the number of Oracle users

Select Username,created,default_tablespace from Dba_users;

Oracle Command Set