FranklinFaces.com - Oracle & SQL Server Database Forums for all IT Professionals / Oracle Forum / ORA - Oracle Database Error Codes - Search via specific error codes. / ORA-20000 Through ORA-29968 / ORA-22929: invalid or missing directory name and ORA-06564: object Xyz does not exist / Latest Posts

RE: ORA-22929: invalid or missing directory name and ORA-06564: object Xyz does not exist

Admin — Mon, 14 Jun 2010 10:03:38 GMT

ORA-22929: invalid or missing directory name

Cause: The required directory name is invalid or missing.

Action: Specify a valid name.

Please add more information about this Error

RE: ORA-22929: invalid or missing directory name and ORA-06564: object Xyz does not exist

Admin — Mon, 14 Jun 2010 10:01:29 GMT

If I'm not wrong, this is wrong:

DEFAULT DIRECTORY /u02/oradata/imp/

"Directory", in this context, isn't a "real" directory which exists on your disk, but Oracle object which is to be created (as a privileged user) using the CREATE DIRECTORY statement.

#/u01/oracle>sqlplus system/pwdcreate or replace directory ext_dir as '/tmp';   --> EXT_DIR is a directory name

grant read, write on directory ext_dir to james;

connect james/james@ora10g

CREATE TABLE ext_table_csv

(  sifra_kpc    VARCHAR2(10),

brojilo      VARCHAR2(20))

ORGANIZATION EXTERNAL( TYPE oracle_loader

DEFAULT DIRECTORY ext_dir                        --> EXT_DIR is then used in CREATE TABLE statement...

RE: ORA-22929: invalid or missing directory name and ORA-06564: object Xyz does not exist

Admin — Mon, 14 Jun 2010 09:57:42 GMT

Directory is an Oracle direcory object not an OS one.

You need to specify the name of the directory not the actual location.

RE: ORA-22929: invalid or missing directory name and ORA-06564: object Xyz does not exist

Admin — Mon, 14 Jun 2010 09:56:50 GMT

Hi

When i execute the following code,following error will come..

ERROR at line 7:
ORA-22929: invalid or missing directory name
Can anyone clarify this..

CREATE TABLE SAMPLE2_EXT (
field1 varchar2(4000)
)
ORGANIZATION EXTERNAL
(
TYPE ORACLE_LOADER
DEFAULT DIRECTORY /u02/oradata/imp/
ACCESS PARAMETERS
(
records delimited by newline
badfile DAT_DIR:'SAMPLE2_EXT%a_%p.bad'
logfile DAT_DIR:'SAMPLE2_EXT%a_%p.log'
fields LRTRIM REJECT ROWS WITH ALL NULL FIELDS (field1 char(4000))
)
LOCATION ('sample2.dat')
)
REJECT LIMIT 10;

ORA-22929: invalid or missing directory name and ORA-06564: object Xyz does not exist

Admin — Mon, 14 Jun 2010 09:55:25 GMT

ORA-22929: invalid or missing directory name and ORA-06564: object Xyz does not exist

You can see this type of ora error when executing a command like:

ALTER TABLE CUSTOMER_SERVICE
DEFAULT DIRECTORY 'IMP_DIR';

ORA-22929: invalid or missing directory name

The problem is in the single quotes surrounding the directory object name.
The same error is also returned when using a CREATE TABLE statement.

The correct syntax requires either double quotes for case sensitive names or no quotes at all for case insensitive names.

ALTER TABLE IMP_BAD_BOXES
DEFAULT DIRECTORY "IMP_DIR";

ALTER TABLE IMP_BAD_BOXES
DEFAULT DIRECTORY IMP_DIR;

Note that when using case sensitive names, if you mistype the name you'll get:

ORA-06564: object Import_Dir does not exist