plz help me to create a directory
600930Aug 12 2008 — edited Aug 13 2008hi guys
i'm trying to create directory to put xml files into it
but i got error messages. as following
-------------------------------------------------------------------
SQL> create directory db2 as 'c:\az';
Directory created.
SQL> Grant all on directory db2 to public
SQL> BEGIN
2 DBMS_XMLSCHEMA.registerSchema(
3 SCHEMAURL=>'http://homepagezz.com/Movies.xsd',
4 SCHEMADOC=>bfilename('db2','Movies.xsd'),
5 LOCAL =>false,
6 GENTYPES=>false,
7 GENTABLES=>FALSE,
8 CSID=>nls_charset_id('AL32UTF8'));
9 END;
10 /
BEGIN
*
ERROR at line 1:
ORA-22285: non-existent directory or file for FILEOPEN operation
ORA-06512: at "SYS.DBMS_LOB", line 635
ORA-06512: at "XDB.DBMS_XMLSCHEMA", line 127
ORA-06512: at line 2
-------------------------------------------------------------------------------------
so plz guys if u know help me