Pando,

I have a quick question. I am trying to build your scripts with mine and I had some problem. Can you help me out???

Let's say if I am in the database A and run the below SQL:

SQL> col today new_value mydate
SQL> set escape /
SQL> select sysdate today from dual;

TODAY
---------
2002SEP12

SQL> spool c:\&mydate/SPOOL.txt
SQL> select 1 from dual;

1
----------
1
and then I have this SQL statement to connect to another database as follow:

SQL> connect system/manager@DATABASE_B
Enter password:

it asked me for the password. seem like I missed soemthing here.

Do you have any advises???

Thanks