Oracle Database的基本操作——创建表空间，用户，授权。。。

关于SQL Plus连接Oracle数据库

1. 图形界面的SQL Plus的Host String。

Host String=[hostname(ip):port/ServiceName]

 

例如本机的Host String可能就是127.0.0.1:1521/orcl OR localhost:1521/orcl

 

2. 命令行连接数据库

 

 

>sqlplus [system/orcl@127.0.0.1:1521/orcl]

 

3. Oracle Net Manager创建Service Naming时创建的tnsnames.ora：

 

 

# tnsnames.ora Network Configuration File: F:/oracle/product/10.2.0/db_1/NETWORK/ADMIN/tnsnames.ora

# Generated by Oracle configuration tools.

 

service_name =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = host_name)(PORT = port_name))

    )

    (CONNECT_DATA =

      (SERVICE_NAME = service_name)

    )

  )

 

ORCL =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = host_name)(PORT = 1521))

    )

    (CONNECT_DATA =

      (SERVICE_NAME = orcl)

    )

  )

 

EXTPROC_CONNECTION_DATA =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))

    )

    (CONNECT_DATA =

      (SID = PLSExtProc)

      (PRESENTATION = RO)

    )

  )

 

 

 

 

1. 创建表空间

 

 

SQL> CREATE TABLESPACE oob

      2  DATAFILE 'F:/oracle/data/sm711_oob.dbf'

      3  SIZE 250M

      4  AUTOEXTEND ON NEXT 50M

      5  MAXSIZE UNLIMITED;

 

2. 创建用户

 

 

SQL> CREATE USER oob

      2  IDENTIFIED BY "oob"

      3  DEFAULT TABLESPACE oob;

 

 

3. 授权

 

SQL> GRANT CONNECT, RESOURCE, DBA TO oob;

 

4. 查询记录

 

SQL> SELECT type FROM infooldm1 WHERE type LIKE 'scdb.system';

 

5. 删除记录

 

SQL> DELETE FROM infooldm1 WHERE type LIKE 'scdb.system';

 

6. 删除表空间

 

DROP TABLESPACE nsn INCLUDING CONTENTS;