Top "Sysdba" questions

grant permission for dbms_crypto

I am using dbms_crypto.encrypt function in my oracle procedure for encryption of passwords. I have connected to oracle …

Read More
oracle permissions grant sysdba dbms-crypto
Running Oracle IMP as SYSDBA

I need to import an ORACLE 9 DMP file into a newly installed Oracle 11g. I'm using the imp utility and …

Read More
oracle imp sysdba
Can't login as sysdba in oracle sqlplus

'hello I am trying to login locally installed oracle 11g database from my windows machine using system / as sysdba Its …

Read More
oracle plsql sqlplus sysdba
Getting "java.sql.SQLException: ORA-28009: connection as SYS should be as SYSDBA or SYSOPER" in groovy

Code is as follows - import groovy.sql.Sql def driver = "oracle.jdbc.OracleDriver" def jdbcUrl = "jdbc:oracle:thin@myhost:1521:…

Read More
java oracle groovy sysdba
how to move undo datafile in running database without disturbing transactions?

Unfortunately one UNDO data file was misplaced in wrong location when I was adding space. I want to move that …

Read More
oracle database-administration data-files sysdba
DataGrip: how to connect to Oracle as SYSDBA

I tried to setup in DataGrip an Oracle connection under SYS user. But got error: ORA-28009: connection as SYS should …

Read More
oracle sys datagrip sysdba