-
编辑 删除
Using Oracle Data Pump to create an external table
一，Create an external table and generate dump file1, Create a directory and assign related privilege(create any directory)SQL> create directory test as '/home/oracle';Directory created.SQL> grant read,write on directory test to system;Grant succeeded.2,Create external tab...
-
编辑 删除
Oracle SQL*Loader
一、SQL*Loader的体系结构 SQL*Loader由一个输入控制文件来控制整个装载的相关描述信息，一个或多个数据文件作为原始数据，其详细组成结构包括 Input Datafiles -->装载到数据库的原始数据文件 ...
-
编辑 删除
Tablespace Encryption in Oracle 11g R1
OverviewIn Oracle Database 10g, Oracle introduced the new Transparent Data Encryption (TDE) feature, which let you easily encrypt a column’s data in a table. The encryption is called transparent because the Oracle database takes care of all the encryption and decryption details, with no need ...
-
编辑 删除
Oracle 数据导入/导出 IMPDP/EXPDP(转)
Oracle 数据导入/导出 IMPDP/EXPDP博客分类： Oracle Backup & Recovery expdp介绍 EXPDP命令行选项 1. ATTACH 该选项用于在客户会话与已存在导出作用之间建立关联.语法如下 ATTACH=[schema_name.]job_name Schema_name用于指定方案名,job_name用于指定导出作业名.注意,如果使用ATTACH选项,在命令行除了连...
