Oracle

Oracle Password Expired

SQL> alter profile DEFAULT limit PASSWORD_REUSE_TIME unlimited; Profile altered. SQL> alter profile DEFAULT limit PASSWORD_LIFE_TIME unlimited; Profile altered. SQL> select username, account_status, EXPIRY_DATE from...
dadin
17 sec read

How to create text file with UTL_FILE

To create text file,as a developer we use “UTL_FILE” concept in oracle. Lets get complete details on this topic. What’s UTL_FILE:- Its a Built...
dadin
1 min read

Generate Insert Script

Here, you can use the following code to generate insert statement to extract the existing data from an oracle table. The generated script can...
dadin
2 min read

Job not Running

If a simple run-once job doesn’t run, you can try restarting the scheduler as follows. SQL> exec dbms_scheduler.set_scheduler_attribute(‘SCHEDULER_DISABLED’, ‘TRUE’); SQL> alter system set job_queue_processes=0;...
dadin
18 sec read

Installing Oracle 10g on Oracle Enterprise Linux 5

Create User and Password $ su – root $ service iptables stop $ chkconfig iptables off $ groupadd -g 1000 dba $ useradd -m...
dadin
1 min read