| Unix pipe and SQLLDR [message #127626] |
Tue, 12 July 2005 10:33  |
whited05
Messages: 10
Registered: May 2005
Location: Lansdale, PA
|
Junior Member |
|
|
Hello all,
Is it possible to use a unix pipe to stream data in to sqlldr?
I have data on server A and want to pipe it to server B and load it into the db. Please let me know if this is possible and mabee some sample code if it is?
Thanks in advance.
Dan
|
|
|
|
| Re: Unix pipe and SQLLDR [message #127642 is a reply to message #127626] |
Tue, 12 July 2005 11:33  |
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
|
Senior Member |
|
|
When you say data on server A do you mean data in a database on server A that needs to go into another database? Can check into DB LINKS for that, or possibly transportable tablespaces.
If you mean raw data, can just copy it over and call sqlldr. Could also use an external table instead of sqlldr and copy data over and that be the end of it, or potentially use a materialized view, depending on your needs and situation.
But, as far as I know, sqlldr is not an interactive program that reads data from stdin to load, it reads data from a file, so I'm not sure where you would pipe data to as you are asking.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
