Home » SQL & PL/SQL » SQL & PL/SQL » plz help
plz help [message #6816] Wed, 07 May 2003 02:37 Go to next message
Cindreen Clarence
Messages: 41
Registered: March 2003
Location: Bangalore
Member
hi all,
is there any method to get the list of directories created by the user for using bfiles?
thanks in advance.

Report message to a moderator

Re: plz help [message #6818 is a reply to message #6816] Wed, 07 May 2003 03:45 Go to previous messageGo to next message
Naveen
Messages: 75
Registered: June 2001
Member
Hi Cindreen,

The owner of the directory would always be sys. You can select the list by using ALL_DIRECTORIES or DBA_DIRECTORIES. Hope this helps.

Regards---Naveen.

Report message to a moderator

Re: plz help [message #6824 is a reply to message #6818] Wed, 07 May 2003 04:54 Go to previous message
Cindreen Clarence
Messages: 41
Registered: March 2003
Location: Bangalore
Member
Hi Naveen,
Thanx for the Help.
Regards.
Cindreen

Report message to a moderator

Previous Topic: How to use dbms_pipe packages or How to send message to all users connected to oracle(Automatically
Next Topic: Query...Urgent help
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 09:51:15 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.