Partition Table Error
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 26
- Joined: Thu Apr 17, 2008 1:38 pm
- Location: Chennai
Partition Table Error
Hi,
I am reading a Oracle source which is range partioned on a key column , i am doing a simple select from the Oracle source using a Oracle EE stage and paassing it to the target dataset. If I perform a normal read without specifying the partition table option, the job reads and loads fine without error. But when i specify the partition table option and then perform the read. I get the following Error ...
"main_program: (aptoci.C:388). Message: ORA-00942: table or view does not exist
(aptoci.C:524). Message: ORA-00942: table or view does not exist
(aptoci.C:436). Message: ORA-00942: table or view does not exist
(aptoci.C:493). Message: ORA-24374: define not done before fetch or execute and fetch".
One thing i can assure is the connection strings are all fine, as the source in the userdefined select and partition table are the same . The source reads 6 rows and loads it to the target as well and the job was finished successfully. But my only concern is why i get the error message
I am reading a Oracle source which is range partioned on a key column , i am doing a simple select from the Oracle source using a Oracle EE stage and paassing it to the target dataset. If I perform a normal read without specifying the partition table option, the job reads and loads fine without error. But when i specify the partition table option and then perform the read. I get the following Error ...
"main_program: (aptoci.C:388). Message: ORA-00942: table or view does not exist
(aptoci.C:524). Message: ORA-00942: table or view does not exist
(aptoci.C:436). Message: ORA-00942: table or view does not exist
(aptoci.C:493). Message: ORA-24374: define not done before fetch or execute and fetch".
One thing i can assure is the connection strings are all fine, as the source in the userdefined select and partition table are the same . The source reads 6 rows and loads it to the target as well and the job was finished successfully. But my only concern is why i get the error message
I'm guessing that between the ORA-24374 and your mention of "userdefined select" that the latter is the issue and you seem to have a mismatch between what's in the sql and the columns you have defined in the stage. If you are saying that you are not allowing the stage to generate the sql, I would be wondering why that is.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Premium Member
- Posts: 26
- Joined: Thu Apr 17, 2008 1:38 pm
- Location: Chennai
Partion Table Error
I tried reading the whole table, using Read Method as Table with all the columns defined. But i still face the same issue.chulett wrote:I'm guessing that between the ORA-24374 and your mention of "userdefined select" that the latter is the issue and you seem to have a mismatch between what's in the sql and the columns you have ...
My Partition Table is RDM.TBL_A, Read method = Table and Table = RDM.TBL_A.
-
- Participant
- Posts: 72
- Joined: Wed Dec 12, 2007 2:29 am
-
- Premium Member
- Posts: 26
- Joined: Thu Apr 17, 2008 1:38 pm
- Location: Chennai
-
- Premium Member
- Posts: 26
- Joined: Thu Apr 17, 2008 1:38 pm
- Location: Chennai
-
- Participant
- Posts: 72
- Joined: Wed Dec 12, 2007 2:29 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 26
- Joined: Thu Apr 17, 2008 1:38 pm
- Location: Chennai
No the problem still persists. I gave the schema name.owner name, but still facing the above error. But intrestingly the job did not abort and is still reading in parallelray.wurlod wrote:Try qualifying the table name with its schema (owner) name. ...
"
main_program: This step has 1 dataset:
ds0: {op0[2p] (parallel Oracle_Enterprise_3)
eAny=>eCollectAny
op1[2p] (parallel Copy_6)}
It has 2 operators:
op0[2p] {(parallel Oracle_Enterprise_3)
on nodes (
node1[op0,p0]
node2[op0,p1]
)}
op1[2p] {(parallel Copy_6)
on nodes (
node1[op1,p0]
node2[op1,p1]
)}
It runs 4 processes on 2 nodes.
"