Issue the following SQL command: ALTER USER IDENTIFIED BY / From Oracle8 you can just type "password" from SQL*Plus, or if you need to change another user's password, type "password user_name".
How do I can quickly open a 8Gb dsv file with 40 million rows with oracle sql developer? I did it with a best laptop with high cpu speed but it took one day, I'm looking for a faster way...