Answer Posted / s.s.kumar

The Structure of the table is known as tablespace,
create tablespace
users
datafile
‘/ora01/oracle/oradata/booktst_users_01.dbf’
size
50m;
using alter query we can manage the tablesapace

Assuming that you are an End User How to find that in the payment Batch some of the Invoice was  Missing To pay How to find That??

1667

---

What is the dynamic sql in oracle?

1006

---

How to bring a tablespace offline?

997

---

What is ASM (Automatic Storage Management) in Oracle?

1121

---

What is the difference between online and offline backups?

970

---

How many types of cluster table in Oracle?

984

---

Which is better Oracle or MS SQL? Why?

4820

---

Explain rename?

922

---

Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.

1791

---

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

2144

---

Why is oracle so popular?

938

---

What is oracle server autotrace in oracle?

1088

---

Difference between the “verify” and “feedback” command?

1308

---

How to delete a user account in oracle?

911

---

How to connect the oracle server as sysdba?

1008

---