How to rename datafiles in Oracle 11g

[Problem]  I want to rename datafile E:\ORACLE\VNPT\DATAFILE\O1_MF_EXAMPLE_CVNONK37_.DBF to E:\ORACLE\VNPT\DATAFILE\EXAMPLE.DBF [FIX] D:\Users\Administrator>sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Mon Aug 22 09:48:56 2016 Copyright...

How to fix the Account Locked (Timed) Oracle

Step 1: Check status of Account: select username, account_status,profile from dba_users where username='APPUSER'; Step 2: Create an profile CREATE PROFILE APP_DEFAULT LIMIT COMPOSITE_LIMIT UNLIMITED SESSIONS_PER_USER UNLIMITED CPU_PER_SESSION UNLIMITED CPU_PER_CALL UNLIMITED LOGICAL_READS_PER_SESSION UNLIMITED LOGICAL_READS_PER_CALL UNLIMITED IDLE_TIME UNLIMITED CONNECT_TIME...

Install or upgrade Oracle APEX 5.0.3 for ORACLE DATABASE 12C on Linux

Step 1: Create tablespace create tablespace apex  datafile '/u01/app/oracle/oradata/PTUD/datafile/apex.dbf' size 100M autoextend on next 10M; Step 2: Download Oracle Apex 5.0.3.00.03 from Oracle or My Google Drive http://www.oracle.com/technetwork/developer-tools/apex/downloads/index.html or...

How to select columns with null values

Connect with your  schema and run the sql scripts SET LINESIZE 32000; SET PAGESIZE 40000; SET LONG 50000; SELECT t.table_name, t.column_name FROM user_tab_columns t WHERE t.nullable = 'Y' AND t.num_distinct = 0 AND t.table_name='TABLE_NAME'; For example: SET LINESIZE...

How to connect PENTAHO with Oracle Database (12c/11g)

Step 1: Set JAVA environment for PENTAHO My Computer --> Properties( Click right mouse My Computer) --> Advanced system settings --> Environment Variables --> User Variables --> New PENTAHO_JAVA=C:\Program Files\Java\jdk1.7.0_79\jre\bin\java.exe PENTAHO_JAVA_HOME=C:\Program...

Example Creating tablespace in Oracle Database.

Create undo tablespace: create undo tablespace undotbs2 datafile '/u01/app/oracle/oradata/ORCL/datafile/undotbs2.dbf' size 100M autoextend on next 10M; Create tablespace: create tablespace BOC datafile '/u01/app/oracle/oradata/ORCL/datafile/BOC.dbf'...