Re: Two Questions Please

From: Kresimir Fabijanic <kfabijanic_at_optusnet.com.au>
Date: Sat, 10 Jul 2004 10:51:02 +1000
Message-ID: <40EF3D76.3030400@optusnet.com.au>

Hi Fahd
fahd mirza wrote:

>Hi Listers,
> I have two questions please.
>1. I am using Oracle 8.1.6, how could I change the password of Internal?
>

Use orapwd utility:

orapwd file=<password filename i.e. d:\oracle\ora9i\dbs\oradb.pwd> password=<your new password i.e. change_on_install> entries=<number of max_users i.e.10>

Make sure that your init.ora remote_login_passwordfile is set to either SHARED or EXCLUSIVE. Confirm that the user is listed in the password file.

SQL> select * from v$pwfile_users;

>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?
>

One way is to use sql script to extract the data into csv file

spool file.out
select col1 || ',' || col2 from tab1 where ....; spool off

your delimiter can be anything (we use '~')

Other way is to use ODBC and create MS Query to query the data directly and load it straight into the Excel..

HTH Kind regards

Kresimir Fabijanic

---

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
-----------------------------------------------------------------

Received on Fri Jul 09 2004 - 19:45:08 CDT