Answer Posted / ravi satyadarshi

//1st of all create a directory to store ur external table
CREATE DIRECORY EMP_DIR AS '/FLAT_FILES' ;


// now write the following line of code to create an
external table at that directory

CREATE TABLE OLDEMP(ENO NUMBER,ENAME CHAR(20),DOB DATE,)
ORGANIZATION EXTERNAL
( TYPE ORACLE_LOADER
DEFAULT DIRECTORY EMP_DIR
ACCESS PARAMETERS
(RECORDS DELIMITED BY NEWLINE
BADFILE 'BAD_EMP')
LOGFILE 'LOG_EMP'
FIELDS TERMINATED BY ','
(ENO CHAR , ENAME CHAR DOB CHAR DATE_FORMAT
DATE MASK "DD-MON-YYYY"
)
)
LOCATION ('EMP1.TXT')
)
PARALLEL 5
REJECT LIMIT 200;

What are the three types of database design?

1023

---

How to generate OIDS

2252

---

Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in

2023

---

What is the database development process?

1217

---

How can I detect whether a given connection is blocked?

1050

---

What are the constraints on severity level in raiseerror?

984

---

What is normalization? Explain different levels of normalization?

63104

---

I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS

2855

---

What are the 18 schemas?

1118

---

What is database design and development?

1015

---

What is the maximum length of an extended property?

983

---

How would you design a database for an online site, which would average a million hits a day?

1009

---

In which table collections errors are stored.

2408

---

What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?

1012

---

What is DB Development software?

2071

---