Answer / shanmugavelu

suppose u have create partition table like,

Sql>Create table Pixel_emp_details(emp_no number,
emp_name varchar2(10))
partition by range (emp_no)
(partition pixel_p1 values less than(10));
Sql>/
Table is created

After that u have use normal insert statement like

Sql> insert into pixel_emp_details partition(pixel_p1)
values(1,'gopi')
SQL> /

1 row created.

What is integrity and what is constraint??Explain with example

1 Answers   Google,

---

How to make a Data Backup in oracle ? What is the procedure for creating the dump files in oracle ( any version ) ?

3 Answers   Satyam,

---

What happens if the imported table already exists?

1 Answers  

---

normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi

1 Answers   iFlex,

---

what is the difference between restoring and recovering?

1 Answers   MCN Solutions,

---

What are the factors that affect OPTIMIZER in choosing an Optimization approach ?

2 Answers  

---

Is oracle the best database?

1 Answers  

---

How can one skip any number of rows while loading the DB tables with SQL Loader? Similarly how can one skip any column?

1 Answers   IBM,

---

what is Single Byte Overhead...?

1 Answers  

---

How to filter out duplications in the returning rows using oracle?

1 Answers  

---

Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.

1 Answers   Wipro,

---

What is archive log in Oracle?

1 Answers   MCN Solutions,

---