Shulou(Shulou.com)06/01 Report--

Rapid deployment of an oracle11G database server that can be used by an application system

-- Yinmo (Sun Zhong)

Query database name:

Select instance_name from v$instance

Create temporary tablespace 500m automatic expansion

Create temporary tablespace zktime_temp

Tempfile'/ data/u01/app/oracle/oradata/zktime_temp.dbf'

Size 500m reuse autoextend on

Query the tablespace data file path:

Select * from dba_data_files

Create a tablespace:

Create tablespace zktime

Datafile'/ data/u01/app/oracle/oradata/zktime_1.dbf'

Size 500m

Autoextend on

New data files for tablespaces:

ALTER TABLESPACE zktime add

Datafile'/ data/u01/app/oracle/oradata/zktime_2.dbf'

Size 500m

Autoextend on

Create a user

CREATE USER zktime

IDENTIFIED BY zktimeoracle11

DEFAULT TABLESPACE zktime

TEMPORARY TABLESPACE zktime_temp

Simple authorization

GRANT CONNECT TO zktime

GRANT RESOURCE TO zktime

GRANT dba TO zktime

Delete tablespaces and database files

DROP TABLESPACE zktime_temp INCLUDING CONTENTS AND DATAFILES

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.