 | |
#1
 
| |||
| |||
|
linked tables -
05-13-2008
, 03:54 PM
#2
| |||
| |||
|
|
Hi, Is there a way of linking in a table into a DB when the table resides in another DB across a network? For example, I have a DB, say myDB. I'd like to be able to import data from a table in another DB, say notMyDB. These two DB's are hosted on different servers. I see that the table is HUGE and importing the entire data into myDB wastes a lot of space. Is it possible for me to create a 'soft link (in unix terms)' to the target table? I'm using Oracle 9.2 Thanks, Sashi |
--
Terry Dykstra
#3
| |||
| |||
|
|
Hi, Is there a way of linking in a table into a DB when the table resides in another DB across a network? For example, I have a DB, say myDB. I'd like to be able to import data from a table in another DB, say notMyDB. These two DB's are hosted on different servers. I see that the table is HUGE and importing the entire data into myDB wastes a lot of space. Is it possible for me to create a 'soft link (in unix terms)' to the target table? I'm using Oracle 9.2 Thanks, Sashi |
--
Terry Dykstra
#4
| |||
| |||
|
|
Hi, Is there a way of linking in a table into a DB when the table resides in another DB across a network? For example, I have a DB, say myDB. I'd like to be able to import data from a table in another DB, say notMyDB. These two DB's are hosted on different servers. I see that the table is HUGE and importing the entire data into myDB wastes a lot of space. Is it possible for me to create a 'soft link (in unix terms)' to the target table? I'm using Oracle 9.2 Thanks, Sashi |
--
Terry Dykstra
#5
| |||
| |||
|
|
Hi, Is there a way of linking in a table into a DB when the table resides in another DB across a network? For example, I have a DB, say myDB. I'd like to be able to import data from a table in another DB, say notMyDB. These two DB's are hosted on different servers. I see that the table is HUGE and importing the entire data into myDB wastes a lot of space. Is it possible for me to create a 'soft link (in unix terms)' to the target table? I'm using Oracle 9.2 Thanks, Sashi |
--
Terry Dykstra
#6
| |||
| |||
|
|
"Sashi" <small... (AT) gmail (DOT) com> wrote in message news:c6616b46-8efa-491d-8333-d22cd540b0ec (AT) w7g2000hsa (DOT) googlegroups.com... Hi, Is there a way of linking in a table into a DB when the table resides in another DB across a network? For example, I have a DB, say myDB. I'd like to be able to import data from a table in another DB, say notMyDB. These two DB's are hosted on different servers. I see that the table is HUGE and importing the entire data into myDB wastes a lot of space. Is it possible for me to create a 'soft link (in unix terms)' to the target table? I'm using Oracle 9.2 Thanks, Sashi Lookup CREATE DATABASE LINK command. -- Terry Dykstra- Hide quoted text - - Show quoted text - |
distributed queries and on designing and using distribued queries in
the DBA Administration Guide.
Other features that still carry the data duplication overhead but may
be more effective from a query performance appoach in some cases are
Replication and Materialized Views. But with Replication at least you
can get Oracle to perform the second database load from the first
rather than have to run two load jobs of the same data.
Terry's suggestion of distributed SQL is how I would start.
HTH -- Mark D Powell --
#7
| |||
| |||
|
|
"Sashi" <small... (AT) gmail (DOT) com> wrote in message news:c6616b46-8efa-491d-8333-d22cd540b0ec (AT) w7g2000hsa (DOT) googlegroups.com... Hi, Is there a way of linking in a table into a DB when the table resides in another DB across a network? For example, I have a DB, say myDB. I'd like to be able to import data from a table in another DB, say notMyDB. These two DB's are hosted on different servers. I see that the table is HUGE and importing the entire data into myDB wastes a lot of space. Is it possible for me to create a 'soft link (in unix terms)' to the target table? I'm using Oracle 9.2 Thanks, Sashi Lookup CREATE DATABASE LINK command. -- Terry Dykstra- Hide quoted text - - Show quoted text - |
distributed queries and on designing and using distribued queries in
the DBA Administration Guide.
Other features that still carry the data duplication overhead but may
be more effective from a query performance appoach in some cases are
Replication and Materialized Views. But with Replication at least you
can get Oracle to perform the second database load from the first
rather than have to run two load jobs of the same data.
Terry's suggestion of distributed SQL is how I would start.
HTH -- Mark D Powell --
#8
| |||
| |||
|
|
"Sashi" <small... (AT) gmail (DOT) com> wrote in message news:c6616b46-8efa-491d-8333-d22cd540b0ec (AT) w7g2000hsa (DOT) googlegroups.com... Hi, Is there a way of linking in a table into a DB when the table resides in another DB across a network? For example, I have a DB, say myDB. I'd like to be able to import data from a table in another DB, say notMyDB. These two DB's are hosted on different servers. I see that the table is HUGE and importing the entire data into myDB wastes a lot of space. Is it possible for me to create a 'soft link (in unix terms)' to the target table? I'm using Oracle 9.2 Thanks, Sashi Lookup CREATE DATABASE LINK command. -- Terry Dykstra- Hide quoted text - - Show quoted text - |
distributed queries and on designing and using distribued queries in
the DBA Administration Guide.
Other features that still carry the data duplication overhead but may
be more effective from a query performance appoach in some cases are
Replication and Materialized Views. But with Replication at least you
can get Oracle to perform the second database load from the first
rather than have to run two load jobs of the same data.
Terry's suggestion of distributed SQL is how I would start.
HTH -- Mark D Powell --
#9
| |||
| |||
|
|
"Sashi" <small... (AT) gmail (DOT) com> wrote in message news:c6616b46-8efa-491d-8333-d22cd540b0ec (AT) w7g2000hsa (DOT) googlegroups.com... Hi, Is there a way of linking in a table into a DB when the table resides in another DB across a network? For example, I have a DB, say myDB. I'd like to be able to import data from a table in another DB, say notMyDB. These two DB's are hosted on different servers. I see that the table is HUGE and importing the entire data into myDB wastes a lot of space. Is it possible for me to create a 'soft link (in unix terms)' to the target table? I'm using Oracle 9.2 Thanks, Sashi Lookup CREATE DATABASE LINK command. -- Terry Dykstra- Hide quoted text - - Show quoted text - |
distributed queries and on designing and using distribued queries in
the DBA Administration Guide.
Other features that still carry the data duplication overhead but may
be more effective from a query performance appoach in some cases are
Replication and Materialized Views. But with Replication at least you
can get Oracle to perform the second database load from the first
rather than have to run two load jobs of the same data.
Terry's suggestion of distributed SQL is how I would start.
HTH -- Mark D Powell --
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.