Oracle creates new tablespace, create user, authorize and import data ____oracle

1. Create user table Space Detail Datasheet space table Tcm_admin
Run under Plsql:
Create Tablespace Tcm_admin
Logging
DataFile ' d:/oracle/product/10.2.0/oradata/tcm_admin.dbf '
Size 1024m
Autoextend on
Next 512m MaxSize Unlimited
Extent management Local;
If you have set up a table tcm_admin table space when the detail warehouse is established, you can no longer create

2. Create user username: fz_net Password: Oracle
Run under Plsql:
Create user ABCD identified by 1234
Default Tablespace tcm_admin

User table space, must be tcm_admin. Because our. dmp file's tablespace is tcm_admin. User name and password can be customized.

3. Authorized to Fz_net users
Run under Plsql:
Grant CONNECT,RESOURCE,DBA to ABCD

4. Create the detail Data Warehouse under the Tcm_admin User:
Windows Start-"run-" cmd to DOS prompt:
IMP ABCD/1234@ABCDEFG file=d:\abcd.dmp full=y