Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

oracle¼ÓÃܺ¯Êý

http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_crypto.htm
oracle×Ô´øÎĵµÐ´µÄ±È½ÏÇå³þ
24

DBMS_CRYPTO
DBMS_CRYPTO
provides an interface to encrypt and
decrypt stored data, and can be used in conjunction with PL/SQL
programs running network communications. It provides support for
several industry-standard encryption and hashing algorithms, including
the Advanced Encryption Standard (AES) encryption algorithm. AES has
been approved by the National Institute of Standards and Technology
(NIST) to replace the Data Encryption Standard (DES).
See Also:
Oracle Database Security Guide
for further information about using this package and about encrypting data in general.
This chapter contains the following topics:
Using the DBMS_CRYPTO Subprograms
Overview
Security Model
Types
Algorithms
Restrictions
Exceptions
Operational Notes
Summary of DBMS_CRYPTO Subprograms
Using the DBMS_CRYPTO Subprograms
Overview
Security Model
Types
Algorithms
Restrictions
Exceptions
Operational Notes
Overview
DBMS_CRYPTO
contains basic cryptographic functions and
procedures. To use this package correctly and securely, a general level
of security expertise is assumed.
The DBMS_CRYPTO
package enables encryption and decryption for common Oracle datatypes, including RAW
and large objects (LOB
s), such as images and sound. Specifically, it supports BLOB
s and CLOB
s. In addition, it provides Globalization Support for encrypting data across different database character sets.
The following cryptographic algorithms are supported:
Data Encryption Standard (DES), Triple DES (3DES, 2-key and 3-key)
Advanced Encryption Standard (AES)
MD5, MD4, and SHA-1 cryptographic hashes
MD5 and SHA-1 Message Authentication Code (MAC)
Block cipher modifiers are also provided with DBMS_CRYPTO
.
You can choose from several padding options, including PKCS (Public Key
Cryptographic Standard) #5, and from four block cipher chaining modes,
including Ciph


Ïà¹ØÎĵµ£º

Oracle³õѧÕß±ØÖªµÄ100¸öÒÉÎÊ

1. Oracle°²×°Íê³ÉºóµÄԭʼ¿ÚÁ
¡¡internal/oracle
¡¡¡¡sys/change_on_install
¡¡¡¡system/manager
¡¡¡¡scott/tiger
¡¡¡¡sysman/oem_temp
2. ORACLE9IAS WEB CACHEµÄԭʼĬÈÏÓû§ºÍÃÜÂ룿
administrator/administrator
3. oracle 8.0.5ÈçºÎ½¨Á¢Êý¾Ý¿â£¿
ÓÃorainst¡£¼ÙÈçÓÐmotif½çÃ棬Äܹ»ÓÃorainst /m¡ ......

Oracleѧϰ±Ê¼Ç

ȨÏÞ¹ÜÀí
Oracle 9i
3¸öĬÈÏÓû§
sys(³¬¼¶¹ÜÀíÔ±)       ĬÈÏÃÜÂ룺change_on_install
system£¨ÆÕͨ¹ÜÀíÔ±£©
ĬÈÏÃÜÂ룺manager
scott£¨ÆÕͨÓû§£©       ĬÈÏÃÜÂ룺tiger
Oracle 10g
sys£¨ÃÜÂëÔÚ°²×°Ê±ÉèÖã©
system£¨ÃÜÂëÔÚ°²×°Ê±ÉèÖã©
scott(ĬÈÏËø¶¨£¬ÏëÓõýâËø)
Æô¶¯Windo ......

ÔÚoracleÖйØÓÚÊ÷µÄsql

±ítask£¬×Ö¶Îid_£¬name_
id_µÄÊý¾ÝÈçÏÂÐÎʽ£º
1
1.1
1.1.1
1.1.1.2
1.2
1.2.1
...
10
10.1
10.1.1
10.2.1
10.2.1.1
10.2.1.1.1
10.2.1.1.2
.......
×¢£º“.”±êʶ¸¸×ӵĹØϵ¡£
ÏÖÔÚͨ¹ýid_²éѯÊ÷½á¹¹µÄЧ¹û£¬²¢ÇÒÖªµÀ´Ë½ÚµãÊÇ·ñΪҶ×Ó½Úµãleaf¡£¡££¿
Óï¾äÈçÏ£º
select
......

oracle Êý¾Ý¿âµÄµ¼Èë/µ¼³ö

OracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓÚoracleÊý¾Ý»¹Ô­Ó뱸·Ý¡£expÃüÁî¿ÉÒÔ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öµ½±¾µØµÄdmpÎļþ£¬impÃüÁî¿ÉÒÔ°ÑdmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶´¦µÄÊý¾Ý¿â·þÎñÆ÷ÖС£
Ö´Ðл·¾³£º¿ÉÒÔÔÚSQLPLUS.EXE»òÕßDOS£¨ÃüÁîÐУ©ÖÐÖ´ÐУ¬ DOSÖпÉÒÔÖ´ÐÐʱÓÉÓÚ ÔÚoracle 8i ÖР °²×°Ä¿Â¼ora81BIN±»ÉèÖÃΪȫ¾Ö·¾¶£¬ ¸ÃÄ¿ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ