You can drop an index in oracle using the DROP INDEX command. It removes the named index. The general Syntax is drop index <schema name>.<index name> ; Here schema name is the owner of the index and index name is the index name. If you don’t provide the schema name, then it is assumed the […]
How to drop table in oracle
The DROP TABLE oracle command is used to remove a table from the database. The dropped table and its data remain no longer available for selection. Dropping a table drops the index and triggers associated with it. Oracle Views, synonym are not dropped but they become invalid Dropped table can be recovered using FLASHBACK utility, if […]
how to import schema in oracle using impdp
We often have a situation where we need to move the schema from Prod to DEV or from test to another. We will discuss how to import schema in the Oracle database using impdp in this situation How to import schema in Oracle 1. First of all we should take the dump of the schema […]
Query to find object dependencies in oracle
Object dependency is important to understand in Oracle. It basically tells the parent-child relationship between the objects. Let’s understand with an example. We create one table CREATE TABLE DEPT_MASTER ( dept_nr NUMBER UNIQUE, dept_name varchar2(100) NOT NULL, dept_status NUMBER(1,0) NOT NULL, created_at date ); Right now this table is alone and it is not dependent […]
How to rebuild the unusable index in oracle
Sometimes when you are rebuilding the table and you forget to rebuild the index after that, then the index of the table will be in unusable status The index can also become unusable with the shrink table command Partition Maintainance operations like split, move, truncate can also render index unusable We can have an index, […]
How to reset MySQL root password on your Linux server
We may sometimes need to reset the MySQL root password on your Linux server. Here are the steps to do that We need the root user privilege to do this Step1 Login as root user and Stop the MySQL server /etc/init.d/mysql stoporservice mysql stop Step 2 Start MySQL in safe mode and skip the use […]
