Oracle creates table spaces, user

CREATE TABLE Space

[SQL]View Plaincopy

1. Create tablespace ' < database name > ' datafile ' < storage path > '
2. Size 500M
3. Default storage
4. (Initial 200m
5. Next 50m
6. Minextents 20
7. Maxextents 500)
8. Online

Example:

[SQL]View Plaincopy

1. Create tablespace itmyhome datafile ' D:\oracle\product\10.2.0\oradata\orcl\itmyhome.dbf '
2. Size 500M
3. Default storage
4. (Initial 200m
5. Next 50m
6. Minextents 20
7. Maxextents 500)
8. Online

< database name > without quotation marks

Create user

[SQL]View Plaincopy

1. --Create User (specify default tablespace and temporary tablespace Specify connection state)
2. CREATE user < username > profile default identified by < password > default
3. Tablespace < tablespace name > temporary tablespace TEMP account UNLOCK;

Authorized

[SQL]View Plaincopy

1. Grant DBA to Testauth;
2. Grant Connect,resource to Testauth;

Oracle Import and Export:

[SQL]View Plaincopy

1. Exp Henanprovince/[email PROTECTED]/ORCL File=d:\province.dmp
2. Imp henanprovince1/[email PROTECTED]/ORCL file=d:\province.dmp full=y
   

Oracle creates table spaces, user