Database Utilities (MOSC)

MOSC Banner

UTL_FILE unable to provide 644 permission to one PDB , no issue in another PDB in same server

Hi

I have found very strange thing here, in same server 2 different container. one is working fine and other is not.

does anyone face this type of issue or any solution available ?

this db HBSGPSNG is creating file 644 while HBSGPGCD is creating file 640 permission.

[oracle@hk01lsngdbd01vp ~]$ sqlplus riz/xxxxxx@HBSGPGCD

SQL*Plus: Release 12.2.0.1.0 Production on Mon Oct 19 11:56:04 2020

Copyright (c) 1982, 2016, Oracle. All rights reserved.

Connected to:

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> DECLARE

out_File UTL_FILE.FILE_TYPE;

BEGIN

out_File := UTL_FILE.FOPEN('RFILE_DATA', 'test19102020.txt' , 'W');

UTL_FILE.PUT_LINE(out_file , 'Testing!');

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