Database Administration (MOSC)

MOSC Banner

why this table x$krbmsft not working in 19c.?

Hi Team,



below query is working fine in APPS instance like development instance. but not working in non-apps instance like SIT,UAT and prod.



SELECT file_name FROM

TABLE ( file_pkg.get_file_list(file_pkg.get_file('directory_path') ) ) all_files

WHERE all_files.is_dir = 'N' ORDER BY 1;



so i got alternate for the same. that is below query. and below query is having this table : - x$krbmsft

but getting this table or view does not exist ORA-00942



Create the function as SYS;

CREATE OR REPLACE FUNCTION xx_list_files (

lp_string IN VARCHAR2 DEFAULT NULL

) RETURN xx_file_array

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