OraFAQ Forum: Server Utilities » loading from other applications

Home » RDBMS Server » Server Utilities » loading from other applications

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

loading from other applications [message #191983]

Sat, 09 September 2006 10:09

vijaychauhan
Messages: 106
Registered: December 2005

Senior Member

hi!
how can I, LOAD DATA FROM ACCEESS USING SQL LOADER.

Report message to a moderator

Re: loading from other applications [message #191984 is a reply to message #191983]

Sat, 09 September 2006 10:30

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Only if the data is extracted to flat files first.

Report message to a moderator

Re: loading from other applications [message #192026 is a reply to message #191984]

Sat, 09 September 2006 21:44

rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia

Senior Member

Depending on the data volumes, it might be better to use an ODBC Link Table to insert the data directly from Access. If this is too slow, then look into SQL*Loader.

Ross Leishman

Report message to a moderator

Re: loading from other applications [message #192279 is a reply to message #191983]

Mon, 11 September 2006 12:14

goudelly
Messages: 52
Registered: August 2006
Location: India

Member

Hi,

The data from access to flat file, text file, excel to csv file make and from there you can use sql*loader.

Thanks,

Mohan Reddy

Report message to a moderator

Previous Topic:	loading by sysdba
Next Topic:	What does the Buffer imply in the Import and Export ?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jun 30 07:06:37 CDT 2024