Tag Info

New answers tagged


You can also avoid the tnsnames.ora file by using the EZ Connect method. sqlplus scott/tiger@asdasdasd.com:1524/<service name goes here> You can get your service name by running lsnrctl status command.


You can manually create the init.ora file. Only 2 parameters are required - db_name and db_block_size. Then run: startup pfile='c:\program\11.2.0\dbhome_1\dbs\init.ora' If you have a valid spfile then run: create pfile from spfile You should be able to startup your database.


column timecol new_value timestamp column spool_extension new_value suffix SELECT TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')||'.csv' spool_extension FROM dual; SELECT TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')||'.csv' spool_extension -- Solved the problem after I added TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS') Hope this can help someone else who is looking for a solution

Top 50 recent answers are included