CREATE DIRECTORY insufficient privileges how-to as non-sys user?
Hello Oracle crowd, i want to issue: CREATE DIRECTORY test_dir AS '/home/work' as a non-sys user or otherwise ordinary user w/ enough privs to ward off the oracle complaint: insufficient privileges. this is part of an oracle how-to for BFILE processing. everything i have read: ROLES, SYNONYMS etc. require the data object to exist prior to issuing the statement. i found a hint that CREATE SCHEMA may help but have so far failed to see how. pls advise, david.