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

=

/ * divided into four steps * /

/ * step 1: create temporary tablespaces (note: d:\ Project\ OracleTableSpace\ FH\ manually create paths) www.1b23.com * /

Create temporary tablespace C##FH_TEMP

Tempfile'D:\ Project\ OracleTableSpace\ FH\ clockFHANGTEMP.dbf'

Size 50m

Autoextend on

Next 50m maxsize 20480m

Extent management local

/ * step 2: create a data tablespace www.1b23.com * /

Create tablespace C##FH_DATA

Logging

Datafile'D:\ Project\ OracleTableSpace\ FH\ centering FHATA.dbf'

Size 50m

Autoextend on

Next 50m maxsize 20480m

Extent management local

/ * step 3: create a user and specify that the tablespace password is root www.1b23.com * /

Create user C##FH identified by root

Default tablespace C##FH_DATA

Temporary tablespace C##FH_TEMP

/ * step 4: grant permissions to the user www.1b23.com * /

Grant connect,resource,dba to C##FH

=

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.