KTEXPERTS – KNOWLEDGE SHARING PLATFORM

Protected: OPERATORS IN PYTHON

7 days ago by TejaPython

There is no excerpt because this is a protected post.

Protected: Installation of PostgreSQL

7 days ago by Prudhvi TejaPostgrSQL

There is no excerpt because this is a protected post.

Protected: Introduction to MongoDB

1 week ago by TejaMongoDB

There is no excerpt because this is a protected post.

Introduction to PostgreSQL

2 weeks ago by Prudhvi TejaPostgreSQL

Introduction to PostgreSQL • PostgreSQL (pronounced as post-gress-Q-L) is a high demand open-source object relational database management system (ORDBMS). It was developed by a worldwide team of volunteers. It is not controlled by any private entity so, it is available for free. • PostgreSQL uses… Read More

FUNCTIONS IN PYTHON

3 weeks ago by Prudhvi TejaPython

FUNCTIONS IN PYTHON FUNCTION : A function is a block of code that executes only when it is called. Data can be passed to functions as parameters. A function can return the result or output the result. In python a function can be created or… Read More

Table/index movement using pl/sql procedure

4 weeks ago by Vinod SiramOracle DB Admin

Table/index movement using pl/sql procedure

CREATE TABLESPACE AWS_DATA01 DATAFILE '+DATA' size 10G
##################### PRE-VALIDATIONS ##################

1 2	CREATE TABLESPACE AWS_DATA01 DATAFILE '+DATA' size 10G ##################### PRE-VALIDATIONS ##################

1) Gather all below data into a SQL log file for future validations

spool TABLE_INDEX_REORG_REBUILD_PREVALIDATIONS.log
set echo on
set linesize 300
col index_name for a30
col degree for a10
col status for a10
col table_name for a30
col owner for a30
col object_type for a20
col constraint_type for a20
col constraint_name for a30
col validated for a20
col degree for a10
set pagesize 100

select owner,object_type,status,count(*) from dba_objects where status <> 'VALID' and owner='SCOTT' group by owner,object_type,status order by owner;
select owner,index_name,status from dba_indexes where TABLE_OWNER='SCOTT' and status<>'VALID';
select index_name,status from dba_ind_partitions where status <> 'USABLE';
select CONSTRAINT_TYPE,STATUS,count(1) from dba_constraints where owner='SCOTT' group by CONSTRAINT_TYPE,STATUS;

set linesize 300
col index_name for a30
col degree for a10
col status for a10

select TABLE_NAME,INDEX_NAME,DEGREE,status from dba_indexes where OWNER='SCOTT' and degree not in (0,1);
select object_type , count(*),status from dba_objects where owner=upper('SCOTT') group by object_type,status order by object_type;
select table_name,index_name,logging from dba_indexes where OWNER='SCOTT' and logging = 'NO';
select distinct STATUS from v$datafile;
select constraint_name,constraint_type,table_name,status,validated from dba_constraints where owner='SCOTT' and status <> 'ENABLED';
select distinct owner from dba_segments where tablespace_name='&tablespace_name';
select distinct owner from dba_tables where tablespace_name='&tablespace_name';
select distinct owner from dba_indexes where tablespace_name='&tablespace_name';
select distinct table_owner from dba_tab_partitions where tablespace_name='&tablespace_name';
select distinct table_owner from dba_tab_subpartitions where tablespace_name='&tablespace_name';
select distinct index_owner from dba_ind_partitions where tablespace_name='&tablespace_name';
select distinct index_owner from dba_ind_subpartitions where tablespace_name='&tablespace_name';
select distinct STATUS from v$datafile;
select * from v$recover_file;
select distinct segment_type from dba_segments where tablespace_name='&tablespace_name';
select distinct status from dba_indexes;
select distinct status from dba_ind_partitions;
select distinct status from dba_ind_subpartitions;

spool off

spool TABLE_INDEX_REORG_REBUILD_PREVALIDATIONS.log

set echo on

set linesize 300

col index_name for a30

col degree for a10

col status for a10

col table_name for a30

col owner for a30

col object_type for a20

col constraint_type for a20

col constraint_name for a30

col validated for a20

col degree for a10

set pagesize 100

select owner,object_type,status,count(*) from dba_objects where status <> 'VALID' and owner='SCOTT' group by owner,object_type,status order by owner;

select owner,index_name,status from dba_indexes where TABLE_OWNER='SCOTT' and status<>'VALID';

select index_name,status from dba_ind_partitions where status <> 'USABLE';

select CONSTRAINT_TYPE,STATUS,count(1) from dba_constraints where owner='SCOTT' group by CONSTRAINT_TYPE,STATUS;

set linesize 300

col index_name for a30

col degree for a10

col status for a10

select TABLE_NAME,INDEX_NAME,DEGREE,status from dba_indexes where OWNER='SCOTT' and degree not in (0,1);

select object_type , count(*),status from dba_objects where owner=upper('SCOTT') group by object_type,status order by object_type;

select table_name,index_name,logging from dba_indexes where OWNER='SCOTT' and logging = 'NO';

select distinct STATUS from v$datafile;

select constraint_name,constraint_type,table_name,status,validated from dba_constraints where owner='SCOTT' and status <> 'ENABLED';

select distinct owner from dba_segments where tablespace_name='&tablespace_name';

select distinct owner from dba_tables where tablespace_name='&tablespace_name';

select distinct owner from dba_indexes where tablespace_name='&tablespace_name';

select distinct table_owner from dba_tab_partitions where tablespace_name='&tablespace_name';

select distinct table_owner from dba_tab_subpartitions where tablespace_name='&tablespace_name';

select distinct index_owner from dba_ind_partitions where tablespace_name='&tablespace_name';

select distinct index_owner from dba_ind_subpartitions where tablespace_name='&tablespace_name';

select distinct STATUS from v$datafile;

select * from v$recover_file;

select distinct segment_type from dba_segments where tablespace_name='&tablespace_name';

select distinct status from dba_indexes;

select distinct status from dba_ind_partitions;

select distinct status from dba_ind_subpartitions;

spool off

2) Export respective schema and whole DB as part of prechecks. 3) Create a Guaranteed Restore point and drop before dropping tablespace if everything is… Read More

Protected: Share Knowledge

4 weeks ago by KTEXPERTS TEAMUncategorized

There is no excerpt because this is a protected post.

LOOPS IN PYTHON

1 month ago by Prudhvi TejaPython

LOOPS IN PYTHON Python language provides three types of loops, They are : while loop for loop nested loop Loop : It is a sequence of statements that will be repeated continuously until a certain condition is met. While Loop : It is used to… Read More

Control Flow In Python

1 month ago by TejaPython

CONTROL FLOW Decision making statements in programming languages decide the direction of the flow of program execution based on the given conditions. Python supports if, Elif used to decide the flow of execution. If statement: It is the basic decision-making statement, in this the code… Read More

Meetup (Get Together)

1 month ago by KTEXPERTS TEAMUncategorized

Hi Guys, Recently we had a very good time in friendly Get Together. Looking forward to many more to come…! Chandler, Arizon Hyderabad