KTEXPERTS – Page 11 – KNOWLEDGE SHARING PLATFORM

Collection Management In MongoDB

Collection : It is a group of documents in a database.collection is like a table in a relational database. The database contains collections,collections contains documents and the documents contain data in it. Naming restriction for collections in MongoDB: 1. Collection name must begin with a… Read More

About JSON and BSON

2 years ago by TejaMongoDB

About JSON and BSON Both JSON and BSON are data interchange formats used for the representation and transmission of data between applications. JSON: (Java script Object Notation) It is text based format that is lightweight and also human readable format. Based on the javascript syntax… Read More

Installation of MongoDB on Windows Operating System

2 years ago by TejaMongoDB

Installation of MongoDB on Windows Operating SystemInstallation of MongoDB on Windows Operating System To download community version, follow these steps. → Click on the link https://www.mongodb.com/try/download/community. → In version section select the version of MongoDB to download. → In platform select windows. → In package… Read More

Installation of Oracle Linux In windows

2 years ago by Prudhvi TejaPostgreSQL

Guide to Installing VirtualBox on Windows for Running Linux Virtual Machines: If you’re a Windows user, who wants to learn PostgreSQL on a Linux Platform, one of the best solutions is to use Linux virtual machines in VirtualBox. In this article, we’ll guide you through… Read More

Installation of PostgreSQL

2 years ago by Prudhvi TejaPostgrSQL

Installation of PostgreSQL As PostgreSQL is an open source, we can download it from official website (www.postgresql.org) by following below steps: Go to official website >> Click on Download >> Choose your System OS >> Click “Download the installer” Select latest version (15.2 present) of… Read More

Introduction to MongoDB

2 years ago by TejaMongoDB

Introduction to MongoDB MongoDB is an open and free NoSQL database management system. It is a document oriented database, i.e. it will store all the data in semi-structured Binary JSON like documents. Features of MongoDB Document Object Data Model: MongoDB stores the data as Binary… Read More

Introduction to PostgreSQL

2 years 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

Table/index movement using pl/sql procedure

2 years 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

2 years ago by KTEXPERTS TEAMUncategorized

There is no excerpt because this is a protected post.

Control Flow In Python

2 years 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