Create table spaces and user names
/* Step 1th: Create a data table space */
Create Tablespace FLX
Logging
DataFile ' E:\oracle\product\10.2.0\oradata\orcl\flx.dbf '
Size 50m
Autoextend on
Next 50m maxsize 20480m
Extent management Local;
/* 2nd step: Create user and specify Tablespace */
Create user FLX identified by FLX
Default Tablespace FLX
/* Step 3rd: Grant permissions to users */
Grant CONNECT,RESOURCE,DBA to FLX;
Import data Structures
Oracle Import DMP File command
1. First go to cmd command window
2. Execute command: Imp userid= user name/password @ database name File=d:\daochu.dmp full=y ignore=y
File: Is the full path of the DMP file you are importing.
Full=y whether all imports are available only when the current user is a DBA.
Existing tables, the import will be error, the table will not be imported, after adding ignore=y on it.
Stop after local listener service starts
E:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\listener.ora to change the contents of this file host= your computer name, restart the next can
Import (export) data with tools selected execution file location
E:\oracle\product\10.2.0\db_1\bin\imp.exe (Exp.exe)
Oracle Local Database connection
