Database Security Products (MOSC)

MOSC Banner

How to encrypt external tables in Oracle

edited Jul 3, 2012 7:18AM in Database Security Products (MOSC) 5 commentsAnswered
Hi Everyone,
We are using Oracle 11.2.0.2.

I knew how to implement encryption of selected columns in Oracle tables.
I read document about modifying the attribute of external table column to create external tables with column encryption. How ever, our external table specifies position of each field in the original external tables. If I modify a few columns, how do I modify the positions of the fields? Here is a external table dll:
create table PION_PARTA_DET_EXT
(
  clmno     VARCHAR2(20),
  prvclmno     VARCHAR2(13),
  clmlnno   VARCHAR2(18),
  memno     VARCHAR2(20),
  nclmtype   VARCHAR2(2),
  clmdatefrom  VARCHAR2(10),
  clmdateto    VARCHAR2(10),
  revcntr   VARCHAR2(4),
  revcntrdt VARCHAR2(10),
  nproc     VARCHAR2(10)
)
organization external

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center