Add UNDO tablespace autoextend tips

Hello,   I need to alter by UNDO tablespace tpo make it autoextend on.  How do I change my UNDO tablespace to allow for autoextend? Show Undo Tablespace in Oracle Database scripts ; CREATE UNDO TABLESPACE UNDOTBS2 DATAFILE ‘+ XDSLBAUNDATA’ SIZE 33554416K AUTOEXTEND OFF, ‘+ XDSLBAUNDATA’ SIZE 33554416K AUTOEXTEND OFF, ‘+ XDSLBAUNDATA’ SIZE 33554416K AUTOEXTEND OFF, ‘+ […]

DBMS_SESSION.CLOSE_DATABASE_LINK

Hello, The CLOSE_DATABASE_LINK procedure is used to close an open but inactive database link in the session. Determining Which Links Are in the Database The following views show the database links that have been defined at the local database and stored in the data dictionary: DBA_DB_LINKS Lists all database links in the database. ALL_DB_LINKS Lists […]

dbms_lock.sleep must be declared error ( Packages Invalid ) solution

Hello, n the Oracle PL/SQL, I want to test the sleep function. I am using PHM_DEV schema. but it gives me error : dbms_lock.sleep must be declared error Schema name : PHM_DEV Cause :The Oracle schema  does not have access to the DBMS_LOCK package. solutions : connect to database ass sysdba grant execute on SYS.DBMS_LOCK to schema_name; […]

Oracle Database Import

Using power of Oracle Data Pump If you haven’t used oracle Data Pump and still using old IMP / EXP, it’s time for change. It’s very simple to use and at least 10 times faster (my experience) than IMP/EXP. Simple steps to configure 1. CREATE OR REPLACE DIRECTORY EXPIMP AS ‘{path}’; 2. GRANT READ, WRITE […]

Show Oracle DB Name and SID name

Hello To find the current DB_NAME and ORACLE_SID: Query the views v$database and v$thread. V$DATABASE gives DB_NAME V$THREAD gives ORACLE_SID If ORACLE_SID = DB_SID and db_name = DBNAME: To find the current value of ORACLE_SID: SVRMGR> select instance from v$thread; INSTANCE —————- DB_SID To find the current value of DB_NAME: SVRMGR> select name from v$database; […]

change Oracle user account status from EXPIRE to OPEN

Hello, Any way to change the Oracle user account status from expire  to open without resetting the password? Solutions: select spare4 from sys.user$ where name='[user name]’; select password from dba_users where username = ‘[user name]’; then : Then use this to reset it: alter user [user name] identified by values ‘[result from above query] Example: […]

ORA-14400: inserted partition key does not map to any partition

Hello in this chapter we are soluting a partition error. Problem descriptions : com.evermind.server.rmi.OrionRemoteException: java.lang.RuntimeException: java.sql.SQLException: ORA-14400: inserted partition key does not map to any partition ORA-06512: at “TMS.PCK_SLA”, line 1766 ORA-06512: at line 1 at com.evermind.server.ejb.EJBUtils.getUserException(EJBUtils.java:296) at DigerHizmetlerIsemriSessionEJB_StatelessSessionBeanWrapper136.isemriTamamla(DigerHizmetlerIsemriSessionEJB_StatelessSessionBeanWrapper136.java:1717) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at com.evermind.server.rmi.RMICallHandler.run(RMICallHandler.java:124) at com.evermind.server.rmi.RMICallHandler.run(RMICallHandler.java:48) at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:192) at […]