ODBC Importer

shilpi2
shilpi2 used Ask the Experts™
on
Hi Experts,

I am trying to move tables from SQL 2 to oracle using ODBC Importer. I am using PL/SQL Developer. When I connect to ODBC importer I only get the master tables and not the user tables under 'Import Table' . What maybe wrong?

Thanks

Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Senior Data Architect
Commented:
Are you sure the account you're using to connect to your SQL Server has rights to view the data that's in those tables (and ideally, the table definitions themselves)? If you have rights to connect to the database, you should see the master tables (though they may appear empty), but you'll need rights to either the objects you want to import, or to the schema that contains them.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial