How to see the Database size and version and RMAN size and version?

aravindhreturns

 Profile Answers by aravindhreturns Questions by aravindhreturns

• Apr 23rd, 2010

To find the ORACLE database size, you need to make a small calculation. The result of these two syntaxes below can be used to find the total allocated size of the database:- select sum(bytes)/10737418...

Answer Question  Select Best Answer

How to drop or delete a datafile which has been miskenly added to a tablespace?

aravindhreturns

 Profile Answers by aravindhreturns Questions by aravindhreturns

• Apr 23rd, 2010

In most environments, this is done using Oracle Import/Export utility since certain privileges are restricted to the DBAs. Steps are below:- 1) Export the data 2) Drop the Tablespace, 3) Import the da...

Answer Question  Select Best Answer

What is the difference between Constraints and Validations?

mrrichardson

 Profile Answers by mrrichardson Questions by mrrichardson

• Jul 12th, 2010

Structured Query LanguageSQL- Is a languagekeywords cannot be abbreviatedSQL *PLUS - More complex than SQLIs a command line tool propietary to Oracle where you can run both SQL and PL/SQL stateme...

Jeremy

• Aug 24th, 2007

SQL*Plus is a client program and interactive interpreter designed for interacting with Oracle databases. SQL is a standard data access language used to describe data access to a variety of databases. ...

Answer Question  Select Best Answer

What are Oracle Catlog & Oracle Archive Log?

What is Growth Factor?

What is dump destination?

What is PCTIncrease in Oracle? How the memory is allocated, reallocated and autoextended while creating tablespaces? What is meant by initial and default in tablespaces and How the next is a multiple of five times DB_BLOCK_SIZE?

In DBMS, What is a relation?

tarpeg

 Profile Answers by tarpeg Questions by tarpeg

• Nov 30th, 2010

Relation is defined as a set of tuples that have the same attributes.

Answer Question  Select Best Answer

How we can decide at run time that which database is going to use among Oracle, SQL Server, MS Access and so on available databases?

In the hint, pq_distribute, which is the outer distribution table and which is the inner distribution table?

What difference does it make to a Oracle developer while using RAC ? Would/Should he realise that it is a RAC Database ?

suji

 Profile Answers by suji Questions by suji

• Mar 21st, 2011

It makes no difference for the developer and RAC technology is server side and affects the way DBA do they day to day job. Thanks, Suji

Answer Question  Select Best Answer

What are archive files? What are the uses with archive files?

pardhudb

 Profile Answers by pardhudb Questions by pardhudb

• Mar 23rd, 2011

Before discussing ?about archive files we will be discuss about redolog files ,these redologfiles records every operation done on the database, ?so when the datafiles are damaged, we can get complet...

GAUTAMJANGRA

 Profile Answers by GAUTAMJANGRA Questions by GAUTAMJANGRA

• Mar 16th, 2011

Archives files are files which are placed together in a bunch for any particular work. Benefit of this is there is no chance of missing of files while transfer from one place to another, also you...

Answer Question  Select Best Answer

How to take backup using RMAN backup, without catalogdb?

gyanudba

 Profile Answers by gyanudba Questions by gyanudba

• Jul 6th, 2011

First you connect to oracle usersu - oracle2then goto cd $ORACLE_HOME/bintype rmanRMAN> connect target;          >  backup database plus archivelog;

smmdba

 Profile Answers by smmdba Questions by smmdba

• Jul 7th, 2008

 How to connect to RMAN without catalog

Answer Question  Select Best Answer

vinoth

• Jul 15th, 2011

Giving privilege to the user

sreekanth.g

 Profile Answers by sreekanth.g Questions by sreekanth.g

• Jun 22nd, 2011

Assume that table 'emp' is created by user scott.by using grant command he can grant privileges to other users.If he want to provide a privileges to grant the privileges to other usershe has to grant a privileges with grant option.

Answer Question  Select Best Answer

How to give private and public database links ?What is syntax for that ?What means mutation in oracle??

dbxplorer

 Profile Answers by dbxplorer Questions by dbxplorer

• Jul 21st, 2011

Database link is the pointer that allow users to access other user's object in remote database. This is one way communication path using database links. Private db links: CREATE DATABASE LINK link_na...

Answer Question  Select Best Answer

How to repair the tnsnames.ora file.
File is completely corrupted and you get network adapter errors and TNS resolve error after restarting the machine.

dbxplorer

 Profile Answers by dbxplorer Questions by dbxplorer

• Jul 21st, 2011

Delete or rename the older file and try to recreate it using "netmgr" using proper information of your database.

Answer Question  Select Best Answer

What is the use of catalog and no catalog in RMAN?

gyanudba

 Profile Answers by gyanudba Questions by gyanudba

• Jul 29th, 2011

Rman with catalog means our target database registered in catalog and its used for recovery purpose. its containing metadata about to database.

rman with no catalog means metadata stored in controlefile through the controlfile we can do the recovery.

Answer Question  Select Best Answer

Explain in detail what are bdump, cdump & udump?

gyanudba

 Profile Answers by gyanudba Questions by gyanudba

• Jul 29th, 2011

background dump (bdump) :--. > bdump is used for all the issues raised related to background process in our database. its also contain alert .log which contain all activities and issues related to da...

Answer Question  Select Best Answer

What is meant by Remote Backup?

gyanudba

 Profile Answers by gyanudba Questions by gyanudba

• Jul 29th, 2011

Suppose as a client u connected to server with the help of some third party tool and you are going to take backup from your server then that is called remote backup.

Answer Question  Select Best Answer