| Table or View doesn't exist [message #385159] |
Fri, 06 February 2009 13:09  |
aarti81
Messages: 235
Registered: December 2007
Location: USA
|
Senior Member |
|
|
Hi all
I created a new instance under the oracle databases module and imported a table into it. Then i went into the staging area and when i tried the deploy the mapping it's giving me the following errors:
ORA-06550: line 29, column 9:
PL/SQL: ORA-00942: table or view does not exist
Please any help or advice is greatly appreciated.
Thanks
|
|
|
|
| Re: Table or View doesn't exist [message #385209 is a reply to message #385159] |
Sat, 07 February 2009 11:10  |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
Please, note that I know nothing about the Warehouse Builder.
However: if the table doesn't exist, there's really not much you can do about it but - create it!
Or, if it exists in another schema, you might grant required privileges to another user which will then be able to use it. Furthermore, this user might also want to create a synonym which will point to the original table so that you shouldn't have to address it with the owner name (for example, "scott.my_table" but simply "my_table").
Now, as you've said that you have imported the table, into which user's schema did you import it? Did you connect to the same schema when doing ... hmmm, mapping?
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
