Thursday, July 17, 2025

SAP Oracle Database table migration to new tablespace using brtools

›
 issue: we have requirement to move the table from tablespace A1 to B1 using brtools. solution: The below script and steps will take care th...
Tuesday, July 15, 2025

script to list the oracle database ORA- errors from oracle Database views

›
  script to list the oracle database ORA- errors COLUMN ORIGINATING_TIMESTAMP FORMAT A40 COLUMN message_text FORMAT A100 set linesize 300 se...

Script to find out user query running which priority in AWS Redshift Database

›
  Script to find out user  query running  which priority in AWS Redshift Database:  SELECT w.query, i.userid, w.service_class, w.state,w.que...

script to find out assumerole granted to user in AWS redshift Database.

›
  script to find out assumerole granted to user in AWS redshift. select username, iam_role, cmd FROM pg_get_iam_role_by_user('TESTUSER@a...

ORA-800 [Set Priority Failed] [VKTM] [Check traces and OS configuration] [Check Oracle 19.24.0.0

›
Issue: we had ORA-800 popping up after the DB creation  and we tried different approaches ,but the error is not going away on oracle databas...
Thursday, March 27, 2025

script to check if the schema part of the data share or not in aws Redshift database

›
 script to check if the schema  part of the data share or not in aws Redshift database:  SELECT * FROM SVV_DATASHARE_OBJECTS where object_ty...

script to check select access for entire schema in AWS Redshift database.

›
  script to check  select access for entire schema in AWS Redshift database. SELECT      tablename,     usename FROM     pg_catalog.pg_table...

script to check user has select,insert,update,delete access on specific schema in AWS Redshift Database

›
 script to check user has select,insert,update,delete  access on specific schema in AWS Redshift Database: SELECT       tablename      ,usen...

script to check user has select,insert,update,delete access on specific table in schema in AWS Redshift Database

›
 script to check user has select,insert,update,delete  access on specific table in schema in AWS Redshift Database SELECT       tablename   ...
Tuesday, October 8, 2024

script to find out table part of the datashare in AWS redshift

›
 script to find out table part of the datashare in AWS redshift: SELECT share_type,     btrim(share_name)::varchar(16) AS share_name,     ob...