user/tablespace sql & export/import

-- export/import
exp pfm3ora/pfm3ora file=pfm3ora.dmp STATISTICS=NONE
imp pfm3ora/pfm3ora full=y ignore=y file=pfm3ora.dmp

-- export한 dump 파일 수동으로 고치기(실패 가능성 다분)
    vi에서..(GRANT 및 PCTFREE로 시작하는 line을 삭제)
    %g/^GRANT/d
    %s/PCTFREE[a-zA-Z0-9 \"-_)(\']*//g




-- create tablespace
CREATE TABLESPACE PFM3ORA DATAFILE
  '/home/oracle/oradata/ora10/pfm3ora.dbf' SIZE 100M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED
LOGGING
ONLINE
PERMANENT
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT MANUAL
FLASHBACK ON;

-- create user
CREATE USER PFM3ORA
  IDENTIFIED BY PFM3ORA
  DEFAULT TABLESPACE PFM3ORA
  TEMPORARY TABLESPACE TEMP
  PROFILE DEFAULT
  ACCOUNT UNLOCK;
  -- 3 Roles for PFM3ORA
  GRANT RESOURCE TO PFM3ORA WITH ADMIN OPTION;
  GRANT DBA TO PFM3ORA WITH ADMIN OPTION;
  GRANT CONNECT TO PFM3ORA WITH ADMIN OPTION;
  ALTER USER PFM3ORA DEFAULT ROLE ALL;
  -- 1 System Privilege for PFM3ORA
  GRANT UNLIMITED TABLESPACE TO PFM3ORA WITH ADMIN OPTION;

-- alter user
alter user pfm3ora identified by pfm3ora;

-- alter tablespace
alter tablespace users add datafile '/mnt/20gb/usersadd.pdf' size 5000M autoextend on next 512 MAXSIZE UNLIMITED;