Skip to Main Content

Java SE (Java Platform, Standard Edition)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

informatica installation problem

ChandanOct 10 2010 — edited Mar 15 2013
Need help

while i am doing node configuration during informatica installation i am getting
following error


The installer could not create the domain. Correct the error below and
select Retry. You must successfully create the domain to continue the
installation.

STDERR: java.lang.NoClassDefFoundError:
com/informatic a/pcsf/common/exception/PCSFException
Exception in thread "main"

Comments

Solomon Yakobson
Answer

1. Typo in MISSING FILED VALUES ARE NULL

2. RECORDS DELIMITED BY NEWLINE must preceed FIELDS TERMINATED BY '|'

3. There is no such SQL*Loader/External table field type VARCHAR2 (in this case you don't even need to specify it)

SQL> CREATE TABLE emp_load
  2       (employee_number      VARCHAR2(50),
  3        employee_last_name   VARCHAR2(50),
  4         employee_first_name  VARCHAR2(50),
  5        employee_middle_name VARCHAR2(50),
  6         employee_hire_date   VARCHAR2(50))
  7      ORGANIZATION EXTERNAL
  8        (TYPE ORACLE_LOADER
  9        DEFAULT DIRECTORY TEMP
10        ACCESS PARAMETERS (
11          RECORDS DELIMITED BY NEWLINE
12          FIELDS TERMINATED BY '|'
13          MISSING FIELD VALUES ARE NULL
14           (employee_number,
15        employee_last_name,
16         employee_first_name,
17        employee_middle_name,
18         employee_hire_date)
19         )
20        LOCATION ('info.dat')
21       ) REJECT LIMIT UNLIMITED
22  /

Table created.

SQL> SELECT  *
  2    FROM  emp_load
  3  /

EMPLOYEE_N EMPLOYEE_L EMPLOYEE_F EMPLOYEE_M EMPLOYEE_HI
---------- ---------- ---------- ---------- -----------
010        ABC        DEF        XYZ        03-DEC-2011

SQL>

SY

Marked as Answer by user12121820 · Sep 27 2020
user12121820

Thanks that worked for me.

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 12 2013
Added on Oct 10 2010
3 comments
730 views