Oracle Table Error

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
Bram
Participant
Posts: 35
Joined: Mon Dec 27, 2004 11:40 am

Oracle Table Error

Post by Bram »

Hi every one,

Does any body tell me how to get the oracle table from my schema into the Oracle oci stage, i am not able to see any tables from my schema.

Thanks,
Bram
dsxuserrio
Participant
Posts: 82
Joined: Thu Dec 02, 2004 10:27 pm
Location: INDIA

Post by dsxuserrio »

After clcking columns, when you click on Load, if you do not see your table definitions, you can click on import and choose builtin metadata definitions.
dsxuserrio

Kannan.N
Bangalore,INDIA
dsxuserrio
Participant
Posts: 82
Joined: Thu Dec 02, 2004 10:27 pm
Location: INDIA

Post by dsxuserrio »

I mean plugin metadata definitions. Sorry
dsxuserrio

Kannan.N
Bangalore,INDIA
chalasaniamith
Participant
Posts: 36
Joined: Wed Feb 16, 2005 5:20 pm
Location: IL

Re: Oracle Table Error

Post by chalasaniamith »

Then u can use the option Import and import whta u want
Sainath.Srinivasan
Participant
Posts: 3337
Joined: Mon Jan 17, 2005 4:49 am
Location: United Kingdom

Post by Sainath.Srinivasan »

In the import you need to provide your Oracle SID, user and password for that schema (or any schema who access synonym or access to it)
Post Reply