Answer / ramesh

From Scott Schema

1.Desc Dept

2.Select Table_name,Column_name,Data_type,nullable from
user_tab_columns wheRE table_name = 'DEPT'

Answer / amrutharao d

1. SQL>Desc Dept

2. SQL>Select Table_name,Column_name,Data_type,nullable from
user_tab_columns wheRE table_name = 'DEPT'

3. SQL>set long 99999
SQL>select dbms_metadata.get_ddl('TABLE','DEPT') from
dual;

I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

1 Answers  

---

What are the different sql server versions you have worked on? : sql server DBA

0 Answers  

---

how will u see whether the dabase is in archive log mode or not?

2 Answers   CSC,

---

WHERE CAN WE SEE THE COMPLETE BACKBROUNG PROCESS IN RAC ENVIRONMENT THROUGH UNIX COMMAND.

2 Answers   Cognizant,

---

Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

0 Answers   Oracle,

---

what is the use of recording information about current session?

0 Answers   Oracle,

---

Name a tablespace automatically created when you create a database.

5 Answers  

---

If we issue alter database begin backup. What happens to database?

2 Answers  

---

How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?

0 Answers  

---

Query processing is slow(eg select query)how will u solve that

3 Answers   TCS,

---

what is grd?

0 Answers   Oracle,

---

How would you determine who has added a row to a table?

4 Answers  

---