Unanswered: Can't select from table after DTS from MSSQL
I exported a sql database into 'test' users schema with the test user / pass used during DTS. I can browse the schema using toad or schema mgr using the test user's credentials. I can not select from any of the imported tables.
I can 'CREATE TABLE ...' and create a new table using the test user and then successfully select from that one?
I have checked the users permissions but can't see anything I am missing.
These are the permissions I have granted the user
GRANT CREATE SESSION TO test;
GRANT CREATE TABLE TO test;
GRANT CREATE VIEW TO test;
GRANT CREATE SEQUENCE TO test;
ALTER USER test QUOTA unlimited ON test;
Any help would be gladly appreciated, I am sure it is something really basic
I get an 'ORA-00942: table or view does not exist' when I try to select from the table.
I have tried prefixing the table with the owners name (test.tablename) which produces the same results.
Could it be something that the DTS transfer has done or not set?