impdp$（sysuser）/$（syspass）directory=dpump_dir1 dumpfile=fmeuc.dmp日志文件=D泵指令1：fmeuc_imp.log remap_schema=fme:fme
“＃！POSITION =” 2081.27 97.2547" ＃！TOP_LEFT = “2081.27 97.2547” ＃！BOTTOM_RIGHT = “2831.27 47.2547” ＃！BOUNDING_RECT = “2081.27 97.2547 750 50” ＃！ORDER = “5E + 14” ＃！FOLLOW_ANCHOR =“真“＃！INFO_NODE =” 假”＃！COLOR = “1,1,0.784314,0.192157” ＃！SIZE_POLICY = “10” ＃！COMMENT_TYPE = “规则的” ＃！ANCHORED_NODE = “0” ＃！/>＃！创建新的数据库目录
dpump_dir1作为系统
指向C:/temp/datafiles
注意文件夹必须存在
“！position=“536.135 722.506”！top_left=“536.135 722.506”！底部_right=“535.135 723.506”！bounding_rect=“536.135 722.506-1-1”！order=“5e+14”！跟随_anchor=“true”！info_node=“false”！colour=“1,1,0.784314,0.192157”！size_policy=“8”！comment_type=“regular”！锚定节点=“19”！/>#啊！生成HTML报表
并显示给用户
“！position=“3832.29 316.631”！top_left=“3832.29 316.631”！底部_right=“3831.29 317.631”！bounding_rect=“3832.29 316.631-1-1”！order=“5e+14”！跟随_anchor=“true”！info_node=“false”！colour=“1,1,0.784314,0.192157”！size_policy=“8”！comment_type=“regular”！锚定节点=“28”！/>#啊！将fme用户创建为系统
“！位置=“-1819.48 491.004”！左上角=“-1819.48 491.004”！右下角=“-1820.48 492.004”！边界直接=“-1819.48 491.004-1-1”！order=“5e+14”！跟随_anchor=“true”！info_node=“false”！colour=“1,1,0.784314,0.192157”！size_policy=“8”！comment_type=“regular”！锚定节点=“31”！/>#啊！系统/fmesys
“！位置=“-1713.23-30.2508”！左上角=“-1713.23-30.2508”！右下角=“-1331.26-129.001”！边界线=“-1713.23-30.2508 381.966 98.7507”！order=“5e+14”！跟随_anchor=“true”！info_node=“false”！colour=“1,1,0.784314,0.192157”！size_policy=“10”！comment_type=“regular”！锚定的节点=“0”！/>#啊！要求：
1）存在本地Oracle XE数据库
2）已知系统用户名和密码-更新相关私有参数
目的：
此工作区创建一个名为FME在现有的本地Oracle / Xe中
数据库作为系统用户。接下来，它通过连接到
数据库。创建该数据库目录后，指向现有的文件夹
在C：\其中包含一个名为FMEUC.DMP一个数据泵文件TEMP \数据文件。
接下来，我们导入此数据泵文件到Oracle数据库
“！位置=“-2778.9 1037.51”！左上角=“-2778.9 1037.51”！右下角=“-1207.01 807.508”！边界矩形=“-2778.9 1037.51 1571.89 230.002”！order=“5e+14”！跟随_anchor=“true”！info_node=“false”！colour=“0,0.66666 7,1,0.266667”！size_policy=“10”！comment_type=“regular”！锚定的节点=“0”！/>#啊！尝试连接的用户FME
“＃！位置=” - 1012.68 591.255" ＃TOP_LEFT =！ “ - 1012.68 591.255” ＃BOTTOM_RIGHT =！ “ - 1013.68 592.255”！＃BOUNDING_RECT = “ - ”！＃ORDER = “1012.68 591.255 -1 -1 5E + 14” #! FOLLOW_ANCHOR="true" #! INFO_NODE="false" #! COLOUR="1,1,0.784314,0.192157" #! SIZE_POLICY="8" #! COMMENT_TYPE="REGULAR" #! ANCHORED_NODE="13" #! /> #!插入查看SDO_GEOM_METADATA
（不EXPDP来）
“＃！位置=” 2728.15 738.506" ＃！TOP_LEFT = “2728.15 738.506” ＃！BOTTOM_RIGHT = “2727.15 739.506” ＃！BOUNDING_RECT = “2728.15 738.506 -1 -1” ＃！ORDER = “5E + 14” ＃！FOLLOW_ANCHOR =“真” ＃！INFO_NODE = “假” ＃！COLOR = “1,1,0.784314,0.192157” ＃！SIZE_POLICY = “8” ＃！COMMENT_TYPE = “规则的” ＃！ANCHORED_NODE = “49” ＃！/>＃！将fme用户创建为系统
“＃！位置=” - 1055.06 1206.64" ＃TOP_LEFT =！ “ - 1055.06 1206.64” ＃BOTTOM_RIGHT =！ “ - 1056.06 1207.64”！＃BOUNDING_RECT = “ - ”！＃ORDER = “1055.06 1206.64 -1 -1 5E + 14” #! FOLLOW_ANCHOR="true" #! INFO_NODE="false" #! COLOUR="1,1,0.784314,0.192157" #! SIZE_POLICY="8" #! COMMENT_TYPE="REGULAR" #! ANCHORED_NODE="73" #! /> #!V9感动数据泵文件和文件夹到C：\ FMEData2017 \资源\ DatabaseWorkshop \ OracleDataPump从C：\ TEMP \数据文件。
假设FMEUC.DMP存在此文件夹中。
“＃！位置=” - 821.883 -222.001" ＃TOP_LEFT =！ “ - 821.883 -222.001” ＃BOTTOM_RIGHT =！ “ - 71.883 -272.001” ＃BOUNDING_RECT =！ “ - ”！＃ORDER =“821.883 -222.001 750 50 5E +14" ＃！FOLLOW_ANCHOR = “真” ＃！INFO_NODE = “假” ＃！COLOR = “1,1,0.784314,0.192157” ＃！SIZE_POLICY = “10” ＃！COMMENT_TYPE = “常规” ＃！ANCHORED_NODE = “0” #! /> #!1.0条编码= US_ASCII独立= 没有？ 几何 尺寸= 2空值 几何 ）FACTORY_DEF $（Creator_CLASSIC）CreationFactory FACTORY_NAME Creator_CLASSIC_Creator $（Creator_2D3D）$（Creator_COORDS）CREATE_AT_END无输出FEATURE_TYPE _____CREATED______ FACTORY_DEF * TeeFactory FACTORY_NAME Creator_Cloner INPUT FEATURE_TYPE _____CREATED______ NUMBER_OF_COPIES 1个COPY_NUMBER_ATTRIBUTE “_creation_instance” 输出FEATURE_TYPE Creator_CREATED @ TCL2（Creator_CoordSysRemover）@CoordSys（）fme_feature_type造物主 FACTORY_DEF * TeeFactory FACTORY_NAME "Creator CREATED Splitter" INPUT FEATURE_TYPE Creator_CREATED OUTPUT FEATURE_TYPE Creator_CREATED_0_GJAgmIF9G6c= OUTPUT FEATURE_TYPE Creator_CREATED_1_Exx7idfjvCA= FACTORY_DEF * BranchingFactory FACTORY_NAME "Creator_CREATED_0_GJAgmIF9G6c= Brancher -1 43" INPUT FEATURE_TYPE Creator_CREATED_0_GJAgmIF9G6c= TARGET_FACTORY "$(WB_CURRENT_CONTEXT)_CREATOR_BRANCH_TARGET" OUTPUT PASSED FEATURE_TYPE * @RemoveAttributes("Creator_CREATED_0_GJAgmIF9G6c= Brancher -1 43".BranchingFactory.Count) FACTORY_DEF * BranchingFactory FACTORY_NAME "Creator_CREATED_1_Exx7idfjvCA= Brancher -1 75" INPUT FEATURE_TYPE Creator_CREATED_1_Exx7idfjvCA= TARGET_FACTORY "$(WB_CURRENT_CONTEXT)_CREATOR_BRANCH_TARGET" OUTPUT PASSED FEATURE_TYPE * @RemoveAttributes("Creator_CREATED_1_Exx7idfjvCA= Brancher -1 75".BranchingFactory.Count) # ------------------------------------------------------------------------- FACTORY_DEF * TeeFactory FACTORY_NAME "$(WB_CURRENT_CONTEXT)_CREATOR_BRANCH_TARGET" INPUT FEATURE_TYPE * OUTPUT FEATURE_TYPE * # ------------------------------------------------------------------------- MACRO SQLExecutor_NewUser_2_DIRECTIVES PERSISTENT_CONNECTION YES USER_NAME "$(SYSUSER)" QUERY_FEATURE_TYPES_FOR_MERGE_FILTERS Yes USE_UNIFIED_DATE_ATTRS YES SHOW_SYSTEM_TABLES NO SERVER_TYPE ORACLE8i REMOVE_SCHEMA_QUALIFIER NO PASSWORD "$(SYSPASS)" FACTORY_DEF * QueryFactory FACTORY_NAME SQLExecutor_NewUser_2 INPUT FEATURE_TYPE Creator_CREATED_1_Exx7idfjvCA= QUERY_SQL "FME_SQL_DELIMITER 下降 用户 FME 级联 下降 目录 dpump_dir1 “READER_TYPE ORACLE_NONSPATIAL READER_DATASET ”@EvaluateExpression（FDIV，STRING_ENCODED，$（OracleDB的$编码），SQLExecutor_NewUser_2）“ COMBINE_ATTRIBUTES RESULT_ONLY COMBINE_GEOMETRY QUERY_ONLY CONTINUE_ON_READER_ERROR YES QUERYFCT_PROPAGATE_IDS_ON_SQL_EXECUTE YES READER_PARAMS $（SQLExecutor_NewUser_2_DIRECTIVES）输出结果FEATURE_TYPE SQLExecutor_NewUser_2_RESULT OUTPUT QUERY FEATURE_TYPE SQLExecutor_NewUser_2_INITIATOR OUTPUT READER_ERROR FEATURE_TYPE SQLExecutor_NewUser_2_ FACTORY_DEF * TeeFactory FACTORY_NAME “SQLExecutor_NewUser_2结果输出Nuker” INPUT FEATURE_TYPE SQLExecutor_NewUser_2_RESULT＃------------------------------------------------------------------------- FACTORY_DEF * TeeFactory FACTORY_NAME “AttributeCreator（禁用）Nuker” INPUT FEATURE_TYPE Creator_CREATED_0_GJAgmIF9G6c= FACTORY_DEF * TeeFactory FACTORY_NAME "AttributeCreator_OUTPUT Disabled Nuker -1 44" INPUT FEATURE_TYPE AttributeCreator_OUTPUT # ------------------------------------------------------------------------- FACTORY_DEF * TeeFactory FACTORY_NAME "Tester (Disabled) Nuker" INPUT FEATURE_TYPE AttributeCreator_OUTPUT FACTORY_DEF * TeeFactory FACTORY_NAME "Tester_FAILED Disabled Nuker -1 39" INPUT FEATURE_TYPE Tester_FAILED # ------------------------------------------------------------------------- FACTORY_DEF * TeeFactory FACTORY_NAME "DontUseBlankUserName (Disabled) Nuker" INPUT FEATURE_TYPE Tester_FAILED # ------------------------------------------------------------------------- MACRO SQLExecutor_NewUser_DIRECTIVES USER_NAME "$(SYSUSER)" QUERY_FEATURE_TYPES_FOR_MERGE_FILTERS Yes SERVER_TYPE ORACLE8i USE_UNIFIED_DATE_ATTRS YES REMOVE_SCHEMA_QUALIFIER NO PERSISTENT_CONNECTION YES SHOW_SYSTEM_TABLES NO PASSWORD "$(SYSPASS)" FACTORY_DEF * QueryFactory FACTORY_NAME SQLExecutor_NewUser INPUT FEATURE_TYPE Tester_PASSED INPUT FEATURE_TYPE SQLExecutor_NewUser_2_INITIATOR INPUT FEATURE_TYPE SQLExecutor_NewUser_2_ QUERY_SQL“@EvaluateExpression（FDIV，STRING_ENCODED，FME_SQL_DELIMITER 创造 用户 $（NEWUSER $编码） IDENTIFIED 通过 $（NEWUSER $编码） 默认 TABLESPACE 临时 TABLESPACE 帐户 开锁 GRANT RESOURCE CONNECT 至 $（NEWUSER $编码） 改变 用户 $（NEWUSER $编码） 默认 角色 RESOURCE CONNECT 改变 用户 $（NEWUSER $编码） 配额 无限 上 选择 计数 * 如 doesuserexists 从 DBA_USERS 哪里 用户名= UPPER $（NEWUSER $编码） ，SQLExecutor_NewUser）” READER_TYPE ORACLE_NONSPATIAL READER_DATASET “@EvaluateExpression（FDIV，STRING_ENCODED，$（OracleDB的$编码），SQLExecutor_NewUser）” COMBINE_ATTRIBUTES RESULT_ONLY COMBINE_GEOMETRY QUERY_ONLY CONTINUE_ON_READER_ERROR YES QUERYFCT_PROPAGATE_IDS_ON_SQL_EXECUTE YES READER_PARAMS $（SQLExecutor_NewUser_DIRECTIVES）输出结果FEATURE_TYPE SQLExecutor_NewUser_RESULT OUTPUT QUERY FEATURE_TYPE SQLExecutor_NewUser_INITIATOR OUTPUT READER_ERROR FEATURE_TYPE SQLExecutor_NewUser_ 输入特性SQLExecutor_NewUser_INITIATOR #——FACTORY_DEF * name userdidgetcreated_logger输入特性SQLExecutor_NewUser_ 输出FEATURE_TYPE UserDidNotGetCreated_LOGGED @Log (“UserDidNotGetCreated:特性是:”,“1”,“1”)@FeatureType (UserDidNotGetCreated_LOGGED) FACTORY_DEF * TeeFactory FACTORY_NAME“UserDidNotGetCreated记录输出核武器”输入FEATURE_TYPE UserDidNotGetCreated_LOGGED # - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -宏SQLExecutor_CheckNewUser_DIRECTIVES USER_NAME " $(列出)"QUERY_FEATURE_TYPES_FOR_MERGE_FILTERS Yes SERVER_TYPE ORACLE8i USE_UNIFIED_DATE_ATTRS Yes REMOVE_SCHEMA_QUALIFIER NO PERSISTENT_CONNECTION Yes SHOW_SYSTEM_TABLES NO PASSWORD "$(NEWUSER)"输入特性SQLExecutor_CheckNewUser类型SQLExecutor_NewUser_RESULT QUERY_SQL "select 用户 连接 如 消息 从 双“READER_TYPE ORACLE_NONSPATIAL READER_DATASET”@EvaluateExpression(FDIV,STRING_ENCODED，$(ORACLEDB$encode)，SQLExecutor_CheckNewUser) COMBINE_ATTRIBUTES RESULT_ONLY COMBINE_GEOMETRY QUERY_ONLY CONTINUE_ON_READER_ERROR YES QUERYFCT_PROPAGATE_IDS_ON_SQL_EXECUTE YES READER_PARAMS $(SQLExecutor_CheckNewUser_DIRECTIVES) OUTPUT RESULT FEATURE_TYPE SQLExecutor_CheckNewUser_RESULT OUTPUT QUERY FEATURE_TYPE SQLExecutor_CheckNewUser_INITIATOR OUTPUT READER_ERROR FEATURE_TYPE SQLExecutor_CheckNewUser_ 输入特性SQLExecutor_CheckNewUser_INITIATOR #——FACTORY_DEF *厂名UserDidNotConnect_Logger输入特性特性_type SQLExecutor_CheckNewUser_ userdidnotconnect_log @Log("UserDidNotConnect:功能 is:","1","1") @FeatureType(UserDidNotConnect_LOGGED) FACTORY_DEF * TeeFactory FACTORY_NAME "UserDidNotConnect LOGGED Output Nuker" INPUT FEATURE_TYPE UserDidNotConnect_LOGGED # ------------------------------------------------------------------------- FACTORY_DEF * TeeFactory FACTORY_NAME UserConnected_Logger INPUT FEATURE_TYPE SQLExecutor_CheckNewUser_RESULT OUTPUT FEATURE_TYPE UserConnected_LOGGED @Log("UserConnected: Feature is:","1","1") @FeatureType(UserConnected_LOGGED) # ------------------------------------------------------------------------- MACRO SQLExecutor_CreateDataPumpDir_DIRECTIVES PERSISTENT_CONNECTION YES REMOVE_SCHEMA_QUALIFIER NO SERVER_TYPE ORACLE8i QUERY_FEATURE_TYPES_FOR_MERGE_FILTERS Yes PASSWORD "$(SYSPASS)" SHOW_SYSTEM_TABLES NO USE_UNIFIED_DATE_ATTRS YES USER_NAME "$(SYSUSER)" FACTORY_DEF * QueryFactory FACTORY_NAME SQLExecutor_CreateDataPumpDir INPUT FEATURE_TYPE UserConnected_LOGGED QUERY_SQL "FME_SQL_DELIMITER ？ 声明 NewDirCreated VARCHAR 30. := mycount 数量 := 0 开始 选择 计数 * 成 mycount 从 all_directories 哪里 directory_name = DPUMP_DIR1 如果 mycount 0 然后 NewDirCreated := 目录 存在 DBMS_OUTPUT.put_line NewDirCreated 其他的 执行 立即 创造 目录 DPUMP_DIR1 作为 C: FMEData2017 资源 DatabaseWorkshop OracleDataPump DBMS_OUTPUT.put_line 创建 新 目录 - DPUMP_DIR1