Re: Oracle 8i: CREATE JAVA CLASS USING BFILE ('c:\temp','Oscar.class');/

Hi,

  Try these steps...

1. First login as svrmgrl or system/manager to grant permission to create a bfile directory.

    svrmgrl> grant create any directory to scott identified by tiger

2. Login as scott/tiger to create the bfile_dir

   sqlplus> create directory bfile_dir as 'c:\temp';

3. load the java class in

   create java class using bfile (bfile_dir,'blah.class');

Allan W. Tham
DBA Received on Mon Sep 03 2001 - 06:33:47 CEST