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

What is the query to change the rows into column and columns into row

oracle2066

 Profile Answers by oracle2066 Questions by oracle2066

• Dec 28th, 2011

Alter table A add column address1 varchar2(10);

Manas Kumar Hati

• Oct 31st, 2011

Unsing Pivot Query

Answer Question  Select Best Answer

Lokesh M

 Profile Answers by Lokesh M Questions by Lokesh M

• Dec 7th, 2011

You can make use of VSIZE function to get the number of bytes in the internal representation of individual field. However this cannot be applied on fields that has BLOB data type and in such case you have to use dbms_lob.getlength function on BLOB data type field.

Answer Question  Select Best Answer

Lokesh M

 Profile Answers by Lokesh M Questions by Lokesh M

• Dec 7th, 2011

Online backup also known as hot backup / open backup can be performed even the database is open and while users are working and is available for read and write activity. To perform Online backup, the ...

Answer Question  Select Best Answer

Why we use Sort_area_size parameter in init.ora file?Kindly let me know?

Lokesh M

 Profile Answers by Lokesh M Questions by Lokesh M

• Dec 7th, 2011

SORT_AREA_SIZE is one of the deferred Oracle Server Parameters which is set in init.ora. Its value as bytes (integer) sets the size of in-memory sort work area. The default is 64K and the maximum valu...

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

Take cold backup and recover

shoaib1786

 Profile Answers by shoaib1786 Questions by shoaib1786

• Nov 5th, 2011

Just create the datafile with same location mention in ur controlfile and recover the datafile ... Its simple.

naveen

• Sep 19th, 2011

Alter database create datafile 'and give the datafile location and /name' by using this command we can recover the datafile without backup also

Answer Question  Select Best Answer

Harieshsivam

 Profile Answers by Harieshsivam Questions by Harieshsivam

• Oct 13th, 2011

Show sga;

we can see the memory of SGA space

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

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

If have 50 inactive session and i want to to kill all session at once tell me the procedure to kill all 50 session at once

muthu5047

 Profile Answers by muthu5047 Questions by muthu5047

• Sep 3rd, 2011

in our project to kill all the inactive session we use the following script.. run the sql script given below it will give u all inactive sessions sid and serial no and redirect output to (inactive_kil...

Answer Question  Select Best Answer

how to see some selected lines in alert log file in unix environment.

like tail -100f alert_SID.log we can see only 100 lines but i need to see the lines between 300 to 500 from down .

muthu5047

 Profile Answers by muthu5047 Questions by muthu5047

• Sep 3rd, 2011

Assuming you need lines 20 to 40,

sed -n '20,40p' file_name

or

awk 'FNR>=20 && FNR

Answer Question  Select Best Answer

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

How will you determine the number of connections connected to your database?

Anupama Kanakam

 Profile Answers by Anupama Kanakam Questions by Anupama Kanakam

• May 29th, 2011

We can also see these connections on Activity monitor. But you need permissions to see it.

jsavarin

 Profile Answers by jsavarin Questions by jsavarin

• Nov 8th, 2010

We can determine the number of connections by using this - SELECT COUNT(*) FROM v$session;

Answer Question  Select Best Answer

How do you control number of Datafiles one can have in an Oracle Database?

dbashashi

 Profile Answers by dbashashi Questions by dbashashi

• Oct 8th, 2010

Without doubt through DB_FILES in Initialization parameter file and not to forget the OS limitation of number of files it can open to process.Shashi singh

mani1304

 Profile Answers by mani1304 Questions by mani1304

• Jul 21st, 2010

Through DB_FILES parameter.

Answer Question  Select Best Answer

What are contents that are not saved in alert log file? What happen when alert log file is full?

dbashashi

 Profile Answers by dbashashi Questions by dbashashi

• Oct 8th, 2010

Almost all the event against the database which may hinder its smooth operation is captured in Alert Log file as error messages.Oracle creates a new alert log files if you delete the current one after taking backup for future reference.Shashi b Singh

Answer Question  Select Best Answer

poojap

 Profile Answers by poojap Questions by poojap

• Oct 6th, 2010

Yes, Archive log files should be on different disk?because?in case of database failure we can get ?the data from the Archive logfiles.

dhs01

 Profile Answers by dhs01 Questions by dhs01

• Apr 15th, 2009

In addition to the previously stated reason that if there is a disk problem, not having them on that disk is a good idea, another issue might be contention. Putting them on the same disk would keep th...

Answer Question  Select Best Answer

HI I installed RHEL4 on my home pc.and I created 2 databases of oracle 10g (same vesrion)The problem is while iam establishing connectivity between these 2 databases iam getting error like TNS-03505: Failed to resolve namemy listerner.ora file isLISTENER=(DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST= (ADDRESS=(PROTOCOL=IPC)(KEY=CHANDU)) (ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521))...

mb.appsdba

 Profile Answers by mb.appsdba Questions by mb.appsdba

• Sep 2nd, 2010

The issue usually occurs when the tns entiries we provide has some unwanted characters or spaces etc.Please also check the tns entry(alias) is pointing to the correct database with sid,hostname etc.If...

maniswamy

 Profile Answers by maniswamy Questions by maniswamy

• Oct 3rd, 2009

Just check your port number if two database are in one PC the port number is changed.

Answer Question  Select Best Answer

If we are running in NOARCHIVELOG mode and my all redo log files are full and data is still not committed by the current session. What activity will Oracle perform and what will happen with the un-comitted data?

ianilreddy

 Profile Answers by ianilreddy Questions by ianilreddy

• Aug 7th, 2010

In database whatever changes we made that going to store in redologs. The changes are record in redolog buffer when certain conditions lgwr will write to redologs 1) When a transaction commit 2)&...

MAbdullah47

 Profile Answers by MAbdullah47 Questions by MAbdullah47

• Feb 5th, 2009

NONARCHIVE log will Protect the DB from Instence faliure but not from Media failure.The Redo files will be covered until the last backup taken , but after that all uncommited datae will be lost for the period (after the last backup) taken.

Answer Question  Select Best Answer

What is the effect on database at the time of total power failure when an UPDATE query is under execution in Oracle 9i?

ianilreddy

 Profile Answers by ianilreddy Questions by ianilreddy

• Aug 7th, 2010

When database is restarted, SMON will perform instance reecoveryRoll forward commited transactionsRoll back uncommited transactions using undo information.

Ram Sangwan

 Profile Answers by Ram Sangwan Questions by Ram Sangwan

• Jun 24th, 2009

When the power failure occurs while an update statement is running. When the database is restarted it does an automatic recovery, when it finds the update statements pending, it performs a rollback of the update statement.Regards-Ram

Answer Question  Select Best Answer