I used the export wizard to export a table to Oracle. I am running Oracle 8i. The wizard said the table was created and when I ran a query in Oracle to see if it was in all_tables, it appeared. When I run a query on the table, the table doesn't exist! Any ideas?
When I try to grant select privileges, it still tells me that the table does not exist. I exported the table from SQL Server to Scott/Tiger. I tried from Scott/Tiger and from SYS and it still says that the table does not exist.
When you run
select * from dba_tables
Who is the OWNER?
Only the owner will be able to see the table unless a public synonym exists or others have been granted privs.
connect as whoever is OWNER of the tablename in question.
If you still get Table or
View does not exist then ????
When I exported the data from SQL Server, I set up the connection to connect to Scott/tiger. So I should be able to see it by connecting to scott/tiger. Like I said, I can see the table name in 'all_tables', but when I want to run a query on the table I get the error message. It says the owner is scott. Again, I got no error from the export wizard in SQL Server.
It doesn't matter if you used scott/tiger to import the table if scott has the priveleges to create a table in another schema (owners) area. If you imported the table as DoeJ.MyTable and there is no public synonym for it you will not be able to select against as MyTable. If you do the select against DoeJ.MyTable then you will see it.
Do this query:[i]
Where table_name = 'TABLENAME';[i]
The result will be the Fully Qualified Name (FQN) of the table.