How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

0 Answers  

---

State any two functions of oracle?

0 Answers   Aricent,

---

Explain the statement?? ALTER TABLE TABLE_NAME MOVE; What it the use of above statement??

1 Answers   BirlaSoft,

---

pls explain connect by prior with example and its real time use

3 Answers  

---

Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

0 Answers   Microsoft,

---

1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE

0 Answers  

---

How to delete a column in an existing table?

0 Answers  

---

What is oracle rowcount?

0 Answers  

---

How to create a new user account in oracle?

0 Answers  

---

does the query needs a hint to access a materialized view?

0 Answers  

---

What is meant by a deadlock situation?

0 Answers  

---

what are indexes..how many types of index's are there and what are they?

7 Answers   Green Info Solutions, TCS,

---