How to Login to Oracle Cloud Database on port 1521 using SSH tunnel with Linux client $ ssh -i private-key-file -L local-port:target-ip-address:target-port opc@target-ip-address private-key-file is the path to the SSH private key file. local-port is the number of an available port on your Linux system. Specify a port number greater than 1023 and less than […]
What is Oracle Partitioned Table? Partitioning divides a table, index, or index-organized table into smaller components. Each component is called a partition (or subpartition for composite partitioned objects). Every partition has a unique name, and may optionally have individual storage characteristics: examples include compression, or being stored in different tablespaces. A well-designed partitioning strategy can
Oracle partitioned table Read More »
About Linux Operating system 1. It was originally developed by Linus Torvalds. It name is mixture of Linus and Unix2.Linux Operating system is modular in design. We have user space and Kernel3. Kernel interacts with Hardware and schedule and use resource like CPU, Memory, storage and network on behalf of application. 4. Application runs in
Linux Operating System and Distributions Read More »
We have to practice the sql statement to become well versed with syntax, restrictions and expression. Oracle Express Edition for windows is a good environment to do practice on your laptop or Desktop . I am going to provide you the step by step installation guide for that. Step by Step Oracle Express Edition Installation
How to Install Oracle Express Edition for SQL Practice Read More »
ORA-00054: resource busy and acquire with NOWAIT specified is a common error seen in Oracle Database Reference: Oracle documentation This generally happens when you try to execute a DDL on the table which is locked by transaction .It also happens if select for update statement is executed with NOWAIT option Example SQL> alter table emp add
ORA-00054: resource busy and acquire with NOWAIT specified Read More »
Here is useful 33 Oracle RMAN interview questions . This is good for both junior level and experienced professional . I hope you like this compilation on Oracle RMAN interview questions. Question 1 What is RMAN?AnswerRMAN stands for recovery manager.it is a utility that can manage your entire Oracle backup and recovery activities. Question 2
Oracle RMAN Interview Questions Read More »
