Home » Developer & Programmer » Data Integration » Table or View doesn't exist (oracle 10.1.2)
Table or View doesn't exist [message #385159] Fri, 06 February 2009 13:09 Go to next message
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 Go to previous messageGo to next message
Littlefoot
Messages: 21806
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?
Re: Table or View doesn't exist [message #386302 is a reply to message #385209] Fri, 13 February 2009 09:05 Go to previous message
aarti81
Messages: 235
Registered: December 2007
Location: USA
Senior Member
Thank You
Previous Topic: OWB 10g (merged)
Next Topic: Missing Records
Goto Forum:
  


Current Time: Fri Mar 29 06:59:54 CDT 2024