Book a Demo

Author Topic: Not able to perfrom DB schema import  (Read 3726 times)

Saurabh

  • EA Novice
  • *
  • Posts: 2
  • Karma: +0/-0
    • View Profile
Not able to perfrom DB schema import
« on: August 13, 2014, 09:58:58 pm »
Hi,

While importing the Database got the message  "Unable to obtain table information".  Not able to find out what's the cause ?

Using:  Database Engineering >> Import DB schema through ODBC.

Installed Oracle 11g and created ODBC DNS through Oracle driver.
EA version = 11
ODBC Test connection is successful.
Also tried various Oracle schema... like system but no luck.

Thanks,
saurabh

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: Not able to perfrom DB schema import
« Reply #1 on: August 14, 2014, 03:59:05 am »
Just a shot into the dark but have you checked permissions?

q.

Saurabh

  • EA Novice
  • *
  • Posts: 2
  • Karma: +0/-0
    • View Profile
Re: Not able to perfrom DB schema import
« Reply #2 on: August 14, 2014, 07:25:16 pm »
Quote
Just a shot into the dark but have you checked permissions?

q.

Thanks,
I also tried DBA Role but no luck... Any specific permission I have to give it Oracle user?

skiwi

  • EA Expert
  • ****
  • Posts: 2081
  • Karma: +46/-82
    • View Profile
Re: Not able to perfrom DB schema import
« Reply #3 on: August 15, 2014, 10:55:12 am »
Quote
Thanks,
I also tried DBA Role but no luck... Any specific permission I have to give it Oracle user?

have you spoken to your own DBAs?
Can you query the database yourself from your desktop>
Orthogonality rules
Position and Team disestablished, thanks austerity.
Now itinerant.