The couple consult everybody, first thank humbly

Environment: operating system, 2008 r2 winserver oracle11g, sqlserver2008r2

Problem: oracle data migrated to MSSQL, using essentially import and export tool to link the oracle database, click next, looked up to more than 6000 objects, the mouse over a morning, didn't find the target table,

And then to recreate in oracle in tablespace testdev, user test02 default testdev, grant connect, the resource, the dba to create the test table and test data

PLSQL with test02 account login successful, under test02 test table, the table has data

Again test used to import and export tool, input test02 account password, tests the link is successful, click next, looked up to more than 4000 objects, or no target table test

Quick collapse of torture, refer to what is the cause of the local, no error, just couldn't find the target table

CodePudding user response:

Use the link
Create a database link that, and then create table as

CodePudding user response:

Sure properly connected to the oracle?

CodePudding user response:

No PIC, no truth