dineshctbm

 Profile Answers by dineshctbm Questions by dineshctbm

• Jul 2nd, 2011

Order By is a keyword which is using for sort the table records either ascending or desending.For eg,for ascending,Select emp_name,emp_identity from emp order by emp_identity;Select emp_name...

nalinicisf

 Profile Answers by nalinicisf Questions by nalinicisf

• May 19th, 2008

contents or data of the table can be sorted by using clause ORDER BY  in SELECT statement.By default the table is in ASCENDING order.SYN: SELECT  * from [table name]    &...

Answer Question  Select Best Answer

mangeshchede

 Profile Answers by mangeshchede Questions by mangeshchede

• Mar 21st, 2010

By using following SQL Command you can grant read only privillege to your user on whole database.SQL > grant select any table to user_name;and dont grant any other privilege to that user.

rajendra_thanekar

 Profile Answers by rajendra_thanekar Questions by rajendra_thanekar

• Apr 9th, 2008

Hi,You can put the entire database in read only mode.startup mountalter database open read only;

Answer Question  Select Best Answer

shekar2130

 Profile Answers by shekar2130 Questions by shekar2130

• Jul 15th, 2010

If we are loosing control file then we will take backup of control file from alertlog file.

rharijan

 Profile Answers by rharijan Questions by rharijan

• Sep 2nd, 2009

If controlfile is lost we can go to the trace file in udump and there after we can create control file by copying the datafile and redologfile and paste in user managed backup by giving old location to a new new location and then try to recover the old one giving the reuse option.

Answer Question  Select Best Answer

sudhakar

• Sep 25th, 2011

1- When BEGIN BACKUP is issued: The hot backup flag in the datafile headers is set, so that the copy is identified to be a hot backup copy. This is to manage the backup consistency issue when the cop...

tykarthick

 Profile Answers by tykarthick Questions by tykarthick

• Oct 6th, 2009

Sql>alter database begin backup;The above query is used to freeze the header of all datafiles belongs to tablespace in that particular database.Freeze means lock i.e during backup no data's wil...

Answer Question  Select Best Answer

Should you take the backup of Logfiles if the database is running in ARCHIVELOG mode?

Shaikh Ziya

• Nov 22nd, 2011

Yes We can Take of Controlfile Online Mode Just
Fire The Command alter database backup controlfile trace And
alter database backup controlfile as trace '/Location where u want 2 take backup of ctlfile/';

sulbha singh

• Sep 22nd, 2011

No, we can not take backup of redo log files even database is running in archive log mode because of inconsistency

Answer Question  Select Best Answer

Chintan

• May 29th, 2012

DDL is Auto Commited Statements.

cmanne

 Profile Answers by cmanne Questions by cmanne

• Mar 25th, 2007

There is no need to issue commit command after executing DDL statements as the DDL statements are commited automatically

Answer Question  Select Best Answer

Neo

• Oct 11th, 2011

Whats the process of refresh ? ( I mean steps). Do you export/import or we take a differential backup and restore on test DB ? Any links to an article will be of great help.

dsp

• Aug 18th, 2011

Hi, There is little diff between them. First we clone the d.b totally(homepath,datafiles,data.....etc) from Prod to Test, where as in D.B Refresh we just refresh the additional data which is in p...

Answer Question  Select Best Answer

Can we read Control file? If yes, then how?

lakshmi143.e

 Profile Answers by lakshmi143.e Questions by lakshmi143.e

• Oct 14th, 2009

SQL> ALTER DATABASE BACKUP controlfile TO trace;
You can find the trace file which is backup of control file in udump directory.

narendra05

 Profile Answers by narendra05 Questions by narendra05

• Oct 2nd, 2009

Control file is the metadata of data and the information is stored in binary format. Some part of the control file can be seen by tracing it to trace (struncture of database can be seen by tracing th...

Answer Question  Select Best Answer

bapiora

 Profile Answers by bapiora Questions by bapiora

• Jun 29th, 2009

As?a dba if you want such info. from your database side.You issue following command from server end.?? select owner,table_name,tablespace_name from dba_tables or if you need some specific user info. issue?? select owner, table_name ,tablespace_name from dba_tables where owner='< username>'

subha gunasekaran

 Profile Answers by subha gunasekaran Questions by subha gunasekaran

• Jun 5th, 2008

select sum(bytes)/1024 from dba_segments where segment_name='TABLE_NAME' and owner=' 'As segment_name represents table_name,index_name..provide the table_name and index_name in the above query

Answer Question  Select Best Answer

SHIMAR

• Apr 17th, 2012

DDL is used to create, alter and truncate
DML is used to insert, update, delete and drop

Venki

• Dec 19th, 2011

DDL means "Data Definition Language". SELECT, UPDATE, INSERT belong to DML, which is "Data Modification Language". DDL is all the other commands -- for example, CREATE TABLE.

Answer Question  Select Best Answer