| DB Links [message #20865] |
Wed, 26 June 2002 09:06  |
kathybb
Messages: 2
Registered: March 2002
|
Junior Member |
|
|
I would like to use a db link to extract data to a flat file. The Oracle 9i documentation states that these links should not be used to extract large file. Can someone define what they consider large? My files range from 1 to 10 mgs.
Thanks,
K
|
|
|
|
| Re: DB Links [message #20867 is a reply to message #20865] |
Wed, 26 June 2002 09:41  |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
you can create a local view/table from the remote database using dblink.
you you can extract data from this view/table to a flat file.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
