Wednesday, June 6, 2018

SQL query to check table size

SELECT segment_name, segment_type, bytes/1024/1024/1024 GB FROM user_segments WHERE segment_type='TABLE' AND segment_name='FBNK_STMT_ENTRY'

Tuesday, June 5, 2018

Apex Installation

Go to the apex directory:
C:\apex>
C:\apex>sqlplus sys/sys123 as sysdba

SQL>

@apexins.sql SYSAUX SYSAUX TEMP /i/

@apxrtins.sql SYSAUX SYSAUX TEMP /i/

@apxchpwd.sql

alter  user apex_public_user account unlock;

alter  user apex_public_user identified by Apex_123;

exec dbms_xdb.sethttpport(0);

@apex_rest_config.sql

----==below script run==
DECLARE
 ACL_PATH VARCHAR2(4000);
BEGIN
 -- Look for the ACL currently assigned to '*' and give APEX_040200
 -- the "connect" privilege if APEX_040200 does not have the privilege yet.
 SELECT ACL INTO ACL_PATH FROM DBA_NETWORK_ACLS
 WHERE HOST = '*' AND LOWER_PORT IS NULL AND UPPER_PORT IS NULL;
 IF DBMS_NETWORK_ACL_ADMIN.CHECK_PRIVILEGE(ACL_PATH, 'APEX_040200',
 'connect') IS NULL THEN
 DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(ACL_PATH,
 'APEX_040200', TRUE, 'connect');
 END IF;
EXCEPTION
 -- When no ACL has been assigned to '*'.
 WHEN NO_DATA_FOUND THEN
 DBMS_NETWORK_ACL_ADMIN.CREATE_ACL('power_users.xml',
 'ACL that lets power users to connect to everywhere',
 'APEX_040200', TRUE, 'connect');
 DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL('power_users.xml','*');
END;
/

@apex_epg_config.sql C:\