SQL
CREATE USER DEV_DEST IDENTIFIED BY DEV_DEST DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP PROFILE DEFAULT QUOTA UNLIMITED ON USERS; GRANT EXECUTE ON SYS.UTL_FILE TO PUBLIC; GRANT ALTER SESSION TO DEV_DEST; GRANT CREATE PROCEDURE TO DEV_DEST; GRANT CREATE SEQUENCE TO DEV_DEST; GRANT CREATE SESSION TO DEV_DEST; GRANT CREATE SYNONYM TO DEV_DEST; GRANT CREATE TABLE TO DEV_DEST; GRANT CREATE TRIGGER TO DEV_DEST; GRANT CREATE VIEW TO DEV_DEST; GRANT SELECT ON SYS.V_$SESSION TO DEV_DEST; GRANT SELECT ON SYS.V_$PROCESS TO DEV_DEST; GRANT ALTER SYSTEM TO DEV_DEST; GRANT DBA TO DEV_DEST; WHENEVER SQLERROR CONTINUE GRANT CREATE JOB TO DEV_DEST;
CREATE DIRECTORY ORG_PUMP_DIR as 'C:\TEMP\DUMP'; GRANT READ, WRITE ON DIRECTORY ORG_PUMP_DIR TO DEV_DEST;
IMPDP system/admin@XE DIRECTORY=ORG_DUMP_DIR DUMPFILE=DEV_SRC_20991231.PMP REMAP_SCHEMA=DEV_SRC:DEV_DEST
EXPDP DEV_DEST/DEV_DEST@XE directory=ORG_PUMP_DIR dumpfile=DEV_DEST_21000101.dmp SCHEMAS=DEV_DEST VERSION=11.2.0
imp DEV_DEST/DEV_DEST@XE file=C:\TEMP\DUMP\DEV_SRC_20991231.dmp fromuser=DEV_SRC touser=DEV_DEST ignore=y exp DEV_DEST/DEV_DEST@XE file=C:\TEMP\DUMP\DEV_DEST_21000101.dmp owner=DEV_DEST
alter user DEV_DEST account unlock;
declare begin プロシージャー名; end; /
SELECT NAME, VALUE FROM V$PARAMETER2 WHERE NAME='utl_file_dir' ;
SELECT VALUE FROM NLS_DATABASE_PARAMETERS WHERE PARAMETER='NLS_CHARACTERSET'
SELECT 子キー, 親キー , LEVEL FROM テーブル WHERE 0 = 0 START WITH 親ルート = 'XXX' CONNECT BY PRIOR 親キー = 子キー
![[PukiWiki]](image/pukiwiki.png "[PukiWiki]")
