We can change the column datatype in a table using alter table modify column in oracle ALTER TABLE table_name MODIFY column_name <action>; Action can be many things like(a) change the data type(b) Shorten or widen the data type(c) Change the default value(d) Change to allow null or not nulls(e) Column Visibility(d) Virtual Column ModificationLet’s start …
alter table modify column in oracle database Read More »
What is Supplemental Logging in Oracle Oracle Redo log file has the record of all the operations performed in the database by default or automatically. So Redo log files are generally used for instance recovery and media recovery. They are also used for Physical standby or physical replication. But by default Oracle redo logs files …
This Find command article is part of Linux tutorials and it has detailed explanations, examples Find command in Unix is an extremely useful command. you can search for any file anywhere using this command provided that file and directory you are searching has read-write attributes set to you, your, group, or all. Find descends directory …
grep command Means – globally search regular expression. It is very useful while searching for strings in Unix and Linux operating system. Here we would be taking a look on grep command in Unix with examples,Linux grep examples,grep command options,egrep command in Unix How to use grep command in Unix The grep utility searches text …
How to use grep command in Unix and Linux with examples Read More »
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 …
In this post, we will check about How to enable archivelog mode in Oracle ( alter database archivelog) in Both Single instance and RAC environments. We will also get to see how to disable the archivelog (alter database noarchivelog) in Both Single and RAC environments. We will also look at the common error ORA-00265. There …
How to enable archivelog mode in Oracle & Disable it Read More »
