Answer Posted / su

CREATE USER <user_name>
IDENTIFIED BY <password>
DEFAULT TABLESPACE <tablespace_name>;

example
CREATE USER su
IDENTIFIED BY su
DEFAULT TABLESPACE users;

if we don't specify the default tablespace name, all the
objects created by the said user will be in the SYSTEM
tablespace which is used by oracle for all its
functionality. Once SYSTEM tablespace gets filled up our
oracle database will stop working

difference of using cursor for loop and open,fetch,close.which one is better

1733

---

Could you please let me know the interfaces in OM / FA??

2186

---

A scenario for amount correction & how to use amount correction functionality in AP invoices

2082

---

What is the importance of batch source set up in ar? : oracle accounts receivable

1197

---

What do you mean by Oracle MEDIA RECOVERY?

1162

---

if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure

2014

---

What is the difference between conversions and interfaces? : oracle accounts receivable

1120

---

3. Steps in UAT?

2365

---

Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

2216

---

Why more redos are generated when the oracle database is in begin backup mode?

1070

---

CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?

2010

---

Explain prerequisites and post activities of oracle database installation

2070

---

Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.

2276

---

what is difference between inner join & nested query or subqueries

2963

---

IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?

2205

---