Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Database > Oracle
Password Reminder
Register
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Oracle General Oracle database discussions.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Oracle section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
 
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old May 5th, 2004, 11:05 AM
Authorized User
 
Join Date: Sep 2003
Location: , , .
Posts: 83
Thanks: 0
Thanked 0 Times in 0 Posts
Default Question about Oracle tools

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

  #2 (permalink)  
Old May 5th, 2004, 12:56 PM
aas aas is offline
Authorized User
 
Join Date: Mar 2004
Location: Moscow, , Russia.
Posts: 26
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to aas
Default

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


  #3 (permalink)  
Old May 5th, 2004, 01:34 PM
Authorized User
 
Join Date: Sep 2003
Location: , , .
Posts: 83
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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

Best,
Pankaj

  #4 (permalink)  
Old May 5th, 2004, 02:23 PM
Authorized User
 
Join Date: Sep 2003
Location: , , .
Posts: 83
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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

 


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
call oracle function using oracle link server vl SQL Server 2000 1 July 12th, 2007 08:19 AM
Tools for Migration of SQL Based Web App To Oracle Netaji Intro Programming 1 September 8th, 2006 05:19 AM
Oracle Spatial Question: ORA-13249 ctteng Oracle 0 August 18th, 2004 06:11 PM
Another Oracle question pankaj_daga Oracle 4 May 11th, 2004 12:09 PM



All times are GMT -4. The time now is 02:18 PM.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.