Tag Archives: sqlplus

How to switch from one user to another in sqlplus

Posted on May 29, 2013 by SoCRaT

for example, you’re connected as sysdba using “sqlplus / as sysdba”, all you have to do is type “connect”, then enter the desired username and password, and there you go!

Posted in Uncategorized | Tagged , , , | 2 Comments

How to get current logged-in user in sqlplus

Posted on May 29, 2013 by SoCRaT

select user from dual;

Posted in Uncategorized | Tagged , , | 2 Comments

Managing the Oracle DB 11g Scheduler Windows (DBMS_SCHEDULER)

Posted on November 25, 2012 by SoCRaT

To display existing scheduler windows, you should query the “dba_scheduler_windows” table: e.g. SELECT WINDOW_NAME,REPEAT_INTERVAL,DURATION,ENABLED FROM dba_scheduler_windows In my case, I needed to disable a window, so that it doesn’t run any scheduled jobs, so I had to run the following: … Continue reading →

Posted in Oracle | Tagged , , , , , , | Leave a comment

Two Simple Methods to Move/Rename Oracle DB Data Files

Posted on November 7, 2012 by SoCRaT

First Method (must be done as sysdba): 1. First, shut down the database: “shutdown immediate;” 2. Rename and/or move data files to new destination using OS commands (e.g. mv for linux) 3. Startup DB in mount mode: “startup mount;” 4. … Continue reading →

Posted in Uncategorized | Tagged , , , , , | Leave a comment

How to compile all Oracle DB 11gR2 Invalid Objects

Posted on September 19, 2012 by SoCRaT

Login to SQLPlus Run the following statement: “@?/rdbms/admin/utlrp.sql”

Posted in Oracle | Tagged , , , , , , | Leave a comment