Hi everyone,

I have very limited database experience. The little experience I have is on SQL server and now I have to port this database to Oracle.

I have the following questions about Oracle:

- What is the best tool to connect to an Oracle database? Something along the lines of SQL server Enterprise Manager? Right now I have the Oracle ODBC client installed and I use Access to connect to it. However, Access does not seem to be able to handle it well.

- Is it possible to change the password for an Oracle user over ODBC? What do I have to do to achieve that?

Thanks,

Sincerely,

Pankaj

If you install the Oracle client on your PC, you can use a TOAD (www.quest.com).
This is one of more the very best tool for Oracle DBA & Developer.

If used ODBS? you be have some mistakes and do not can use some features of Oracle DB.

I use the TOAD till present time (about 7 years)

Best regards
Andrew

Thanks man. I will download the trial version and give it a spin.

Best,
Pankaj

Hi everyone,

It looks like I have installed the InstantClient package from Oracle. However, I do not know which is the regular Oracle client package that I need to install. Can you point me a link to where I can download and find more about the regular client. I heard that the regular client has its own "Enterprise Manager" like features to connect to running instances of Oracle databases.

Thanks,

Pankaj