Home » SQL & PL/SQL » SQL & PL/SQL » External table (oracle10g Linux)
External table [message #298481] Wed, 06 February 2008 03:32 Go to next message
sundarfaq
Messages: 235
Registered: October 2007
Location: Chennai
Senior Member
Hi,
I created a external table in Windows OS and oracle9i but i unable to create a external table in LINUX and oracle10g.

Scripts:

In Windows machine:

CREATE TABLE SHIP_EMPLOYEES1
(
employees_Key NUMBER(9),
employees_bank_No VARCHAR2(11),
department VARCHAR2(3),
salary VARCHAR2(Cool,
bonus VARCHAR2(3),
class VARCHAR2(3),
place VARCHAR2(3),
phone_number VARCHAR2(3)
)
ORGANIZATION EXTERNAL
( TYPE ORACLE_LOADER
DEFAULT DIRECTORY data_dir
ACCESS PARAMETERS
( RECORDS DELIMITED BY '\n'
FIELDS TERMINATED BY '',''
MISSING FIELD VALUES ARE NULL )
LOCATION ('SHIPMENT.csv')
)
REJECT LIMIT 100000
LOGGING
NOCACHE
PARALLEL ( DEGREE 4 INSTANCES 1 );

Table created.

In Linux machine:

CREATE TABLE SHIP_EMPLOYEES1
(
employees_Key NUMBER(9),
employees_bank_No VARCHAR2(11),
department VARCHAR2(3),
salary VARCHAR2(Cool,
bonus VARCHAR2(3),
class VARCHAR2(3),
place VARCHAR2(3),
phone_number VARCHAR2(3)
)
ORGANIZATION EXTERNAL
( TYPE ORACLE_LOADER
DEFAULT DIRECTORY data_dir
ACCESS PARAMETERS
( RECORDS DELIMITED BY '\n'
FIELDS TERMINATED BY '',''
MISSING FIELD VALUES ARE NULL )
LOCATION ('SHIPMENT.csv')
)
REJECT LIMIT 100000
LOGGING
NOCACHE
PARALLEL ( DEGREE 4 INSTANCES 1 );

It shows a error like

ORA-30657: operation not supported on external organized table

How can i resolve it?
Re: External table [message #298485 is a reply to message #298481] Wed, 06 February 2008 03:57 Go to previous messageGo to next message
Littlefoot
Messages: 20896
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Remove LOGGING and NOCACHE.
Re: External table [message #298486 is a reply to message #298481] Wed, 06 February 2008 03:59 Go to previous message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
As I already said in some of your previous posts:
Michel Cadot wrote on Tue, 16 October 2007 13:53
I Please read and follow OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format. Use the "Preview Message" button.
Please always post your Oracle version (4 decimals).

Regards
Michel

Previous Topic: I need to sort out age from a list.
Next Topic: summing up values...
Goto Forum:
  


Current Time: Tue Dec 06 08:52:22 CST 2016

Total time taken to generate the page: 0.06317 seconds