importing oracle tables/views into sql server

[beechill4]

Hi,

i am trying to import the following data dictionary views into my sql server database from Oracle:

dba_indexes
dba_users
dba_tables.

I am having a problem seeing them though in the list of tables and views i get when i try and import them.
the oracle connection from sql server is good and the user i am using has permission to view the views above.

Is there something i can do to get around this?

Thanks in advance.

 

[DrSql]

Try to create an ODBC and to your ORacle DB and assign to the destination. Then try to import. Good luck

Dr. Sql
goEdeveloper@yahoo.com
Good Luck.

 

[beechill4]

Hi,

i have the odbc created already. i can see some schemas but not those owned by sys. yet when o log on to sql plus i can see the sys owned tables.

 

[NuniPR]

I have a few questions regarding this also...

First, isn't ODBC extremely slow when working with millions of records?

Second, will field types be in sync? Will SQL recognize them and maybe convert them to something useful?

Third, if the first question is true, is there any other way to go about linking them in a way that will make it faster?

Thanks guys!!

Nunina
Cognos BI Administrator
San Juan, PR

 

[icemel]

Why not just create your *own* table and dump the data from the Oracle system tables into them?

Then, perhaps they will show up on your connection, since they will no longer be special system tables.

 

[DrSql]

I think you are having database alias conflicts. The user that you using to connect to the Oracle db should have previllages for all alias.tables that you want to access. Verify with your Oracle DB. To verfiy this use your Oracle dba account.

Dr.Sql
Good Luck.

 

[NuniPR]

Hi Dr. Sql,

I am the Oracle DBA in this case... )

I still haven't tried to do this; just doing some research, since it'll be my next task.

Thanks for your help, and if you know where to get exact instructions or ideas, please let me know.

Thanks!

Nunina