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

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

872

---

What is the mandatory setup in cyclecount ?

2405

---

WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?

2588

---

1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count

16889

---

What is supporting issues GL AP and AR?

2206

---

---

What Are Cross Validation & Adi?

880

---

what is the link between suppliers and banks in ap module in oracle apps? And also query?

2206

---

How to clone the database using RMAN back

1807

---

What is db_recovery_file_dest in oracle? When do you need to set this value?

868

---

what ASIS BUSINESS PROCESS IN ORACLE FINANCE

1997

---

What are different types of receipt reversals ? Explain them : oracle accounts receivable

942

---

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

1730

---

What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f

4163

---

Are These Dff's Flexible?

903

---

what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable

826

---