Delphix Products

Hi Suzanne ,

Per definition oracle allows read-only access to data in external tables (they don' reside in the database), so to achieve your need you will have two options :

- If the file format is supported by delphix masking :
  Mask the original file on wish the external table is based and rerun the "create or replace command for the external table", notice you can automate the process using delphix Vfile and hooks

- If the file format isn't supported by delphix masking :
Create a copy of external table on database using (create as select...), mask the table with delphix masking once done export the data out to the file on which the external table is base and rerun the "create or replace command for the external table"

Regards,

Mouhssine  

I think Mouhssine and I replied at the same time:)  Mouhssines advice is correct apart from one small step.

"rerun the "create or replace command for the external table"" - this isn't necessary.  The external table is defined once and any changes to data in the external file will be seen when you query the table.  In actual fact there is no "create or replace" command.

You only need to drop and recreate (or alter) the external table if the structure of the external file changes.

Hi Suzanne ,

Per definition oracle allows read-only access to data in external tables (they don' reside in the database), so to achieve your need you will have two options :

- If the file format is supported by delphix masking :
  Mask the original file on wish the external table is based and rerun the "create or replace command for the external table", notice you can automate the process using delphix Vfile and hooks

- If the file format isn't supported by delphix masking :
Create a copy of external table on database using (create as select...), mask the table with delphix masking once done export the data out to the file on which the external table is base and rerun the "create or replace command for the external table"

Regards,

Mouhssine  

I think Mouhssine and I replied at the same time:)  Mouhssines advice is correct apart from one small step.

"rerun the "create or replace command for the external table"" - this isn't necessary.  The external table is defined once and any changes to data in the external file will be seen when you query the table.  In actual fact there is no "create or replace" command.

You only need to drop and recreate (or alter) the external table if the structure of the external file changes.