Configure table space, create users, and import Databases

Configure table space, create users, and import Databases

--- Cmd go to the dos interface sqlplus/as sysdba ---- create table space --- create tablespace ciqpspace DATAFILE 'd: \ oracle \ product \ 10.2.0 \ oradata \ orcl \ CIQP when creating the dbf file. DBF 'size 30 M reuse autoextend on next 5 m maxsize unlimited extent management local autoallocate segment space management auto; -- create user fqs identified by "1" default tablespace fqs01 temporary tablespace temp; grant connect, resource to fqs; grant unlimited tablespace to fqs; grant dba to fqs; create tablespace mcsspace logging datafile 'e: \ mcs20130415.dmp 'size 50 m autoextend on next 50 m maxsize 20480 m extent management local; imp ciqpf/ciqpf @ orcl file = e: /ciqp20130413.dmp full = y create tablespace mcsspace size 50 m autoextend on next 50 m maxsize 20480 m extent management local; C: \ Documents ents and Settings \ Administrator> exp ciqp/ciqp @ orcl_1_file = e:/ciqp2013 0412.dmp imp full = y exp mcs/1 @ orcl_1_file = e:/mcs. dmp imp mcs/mcs @ orcl file = e:/mcs. dmp full = y