Database Software

Hello All:

I am new to Warehouse Builder and have several questions. First, let me tell you a little about the environment I'm working in. These are the relevant (I hope) details of
our installation:

OWB10G Design Client (10.1.0.2.0) installed on my PC.
OWB10G Design Schema installed in Oracle 9.2 database 'tstrac1'.
OWB10G Runtime Access User (owb10grun), Runtime Repository Schema (owb10grep), and Target Schema (owb10gsch) installed in a second Oracle 9.2 database 'nsudev'. The
Oracle 9.2 database 'nsudev' also contains the existing schemas BUILDER and IGS.


This is what I need to accomplish:

Copy data from fields in existing tables in the BUILDER schema into fields in existing tables in the IGS schema.

Our DBA was not able to install a Target Schema into the existing schema IGS. At this time, I do not have details of the error(s) encountered.


These are my questions:

1) Is it true that, if I want to use a mapping to update the data in an existing table, I must install the Target Schema into the same schema as the existing table?

2) I have created a mapping with my Source module (OSS_LEGACY_DATA) and Target module (OSS_IGS_INT_TABLES) in the same database (nsudev). I have created 'Locations' for both of these modules (SOURCE_LOC and TARGET_LOC). I have also created a connector for each location (S_LOC_CON and T_LOC_CON). I have been able to Register and Validate both locations and the T_LOC_CON connector but I am having a problem with the S_LOC_CON connector.

When I try to deploy and execute the mapping everything seems to work Ok except the SS_LOC_CON (source) connector. The error message I am getting is:

ORA-01031: insufficient privileges

Is it the Runtime Repository Schema (owb10grep) that doesn't have the correct privileges? Or is it the Runtime Access User (owb10grun)?

3) Why do I even need 'Connectors'. The database links I created at the beginning of this project worked just fine to allow me to import the metadata to the tables in my mapping. Why can't those links be used to read data from the Source and write it to the Target?

4) Some of the things I've read make it seem like I only need one connector if both the Source and Target are in the same database. Other documentation makes it seem as if I always need one connector for each location. Which is true?

Thanks in advance for your help.