login with sys as sysdba
----First create the directory ----
CREATE OR REPLACE DIRECTORY EXT_TABLES AS 'C:\temp\';
---After creating the directory --------
----Give the grant to hr-------
Grant Read on directory EXT_TABLES to HR;
----after granting the access to hr
then create the table --------
CREATE TABLE countries_ext (
country_code VARCHAR2(5),
country_name VARCHAR2(50),
country_language VARCHAR2(50)
)
ORGANIZATION EXTERNAL (
TYPE ORACLE_LOADER
DEFAULT DIRECTORY ext_tables
ACCESS PARAMETERS (
RECORDS DELIMITED BY NEWLINE
FIELDS TERMINATED BY ','
MISSING FIELD VALUES ARE NULL
(
country_code CHAR(5),
country_name CHAR(50),
country_language CHAR(50)
)
)
LOCATION ('Countries1.txt','Countries2.txt')
)
PARALLEL 5
REJECT LIMIT UNLIMITED;
------------
SELECT * FROM countries_ext
---------
--If the load files have not been saved in the appropriate directory the following result will be displayed:--
SQL> SELECT *
2 FROM countries_ext
SELECT *
*
ERROR at line 1:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-04040: file Countries1.txt in EXT_TABLES not found
ORA-06512: at "SYS.ORACLE_LOADER", line 14
ORA-06512: at line 1
my name is suraj
ReplyDeletesir please provide information about reporting service and integration service in sqlserver 2005