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:\
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:\
Subscribe to:
Posts (Atom)