-
Book Overview & Buying
-
Table Of Contents
Oracle 11g Anti-hacker's Cookbook
By :
Table or full database dumps can also be a major source of information theft in case it is not protected. Oracle also provides encryption options for data pump exports using TDE or passwords. In this recipe we will generate dumps by exporting the HR schema using different encryption options. Next, we will import each dump by remapping the tablespace USERS to the tablespace ENCRYPTED_TBS, and using related options.
All steps will be performed on the database HACKDB.
Create a directory /security/datapump for dumps and change its ownership to the user oracle:
mkdir –p /backup/datapump chown oracle:oinstall /backup/datapump
Connect as the user system and create an oracle directory mapped to the /backup/datapump directory by executing the following statement:
SQL> create directory encrypted_dumps as '/storage/datapump'; Directory created.
Export the schema HR by using the all option and the encryption mode transparent as follows...
Change the font size
Change margin width
Change background colour