Answer Posted / 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.

Respected sir, Please send me technical questions related to oracle apps..

1562

---

List the types of joins used in writing subqueries?

744

---

What is the use of file param in imp command?

863

---

How to retrieve data from an explicit cursor?

762

---

What is the quickest way to export a table to a flat file?

738

---

Explain the use of log option in exp command.

730

---

In oracle there is column command, how will you explain that?

715

---

How to run create database statement again?

790

---

What are the parameters that we can pass through a stored procedure?

798

---

What is the Tune Query

2047

---

What are the different windows events activated at runtime ?

2591

---

can anyody please send me the dump for Oracle 10g certifications for DBA path?

1904

---

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1640

---

What is the difference between translate and replace in oracle?

893

---

Explain database link?

850

---