RE: Two Questions Please

From: Hostetter, Jay M <JHostetter_at_decommunications.com>
Date: Fri, 9 Jul 2004 08:04:29 -0400
Message-ID: <D67EB7CEECD4334F9C85759227553BBC1CAA89@CL-EXCHANGE1.dande.com>

What OS are you on? On Unix, connect internal will NOT prompt your for a password if you are logged into the box as an OS user that is in the dba group (or whatever group you specified at installation). So if you are being prompted for a password when connecting as internal, your OS user isn't in the dba group. However, you can try your SYS password, since internal really connects as SYS.
Setup an ODBC entry for your database. Then go into Excel (in Excel
and select : Data, Get External Data, New Database Query, then choose your data source and follow the wizard.

Jay

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of fahd mirza Sent: Friday, July 09, 2004 4:51 AM
To: Active DBA
Subject: Two Questions Please

Hi Listers,

I have two questions please.
1. I am using Oracle 8.1.6, how could I change the password of Internal? 2. How can I move the data of a table from Oracle to Excel? Does Oracle provide any tool for this like it provides SQL Loader to do otherwise? Thanks in advance.
regards,
Fahd

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

**DISCLAIMER

This e-mail message and any files transmitted with it are intended for the =
use of the individual or entity to which they are addressed and may contain=
 information that is privileged, proprietary and confidential. If you are n=
ot the intended recipient, you may not use, copy or disclose to anyone the =
message or any information contained in the message. If you have received t=
his communication in error, please notify the sender and delete this e-mail=
 message. The contents do not represent the opinion of D&E except to the ex=

tent that it relates to their official business.

Please see the official ORACLE-L FAQ: http://www.orafaq.com

Received on Fri Jul 09 2004 - 07:01:22 CDT