Monthly Archives: luglio 2016

ORACLE 12C : Extended Data Type
  • 27
    Lug

ORACLE 12C : Extended Data Type

With the previous Oracle database release, long characters strings of more then 4000 bytes had to be handled using CLOB or LONG data types. Starting from Oracle 12c was introduced a new system parameter: MAX_STRING_SIZE. This parameter allows string data types to be much larger when the parameter is changed from its default value STANDARD to EXTENDED. New...

Read More
ORACLE 12C: Expdp encryption password
  • 6
    Lug

ORACLE 12C: Expdp encryption password

Starting from release 12C there is a new option to pass in silent mode encryption password . The ENCRYPTION_PWD_PROMPT parameter enables encryption without requiring the password to be entered as a command line parameter. The user is prompted for the password during export utility. expdp ... ENCRYPTION_PWD_PROMPT=Y Password: <user is asked for encryption password> In previous release encryption...

Read More