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 oracle media recovery and crash recovery?

1176

---

which one is currently in used software cmpanies.

2153

---

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

7674

---

I am Bsc Computer Science Graduate, I have good knowledge in SQL 7.0, Can I go for Oracle APPS course please suggest me the answer

2264

---

WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?

2026

---

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

1127

---

Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable

1295

---

8. Supporting AP, AR and GL?

2311

---

WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?

2955

---

what is semphore explian it?

2815

---

can u pls share responsibilities for production how to environment in odi?and how to generate report ?

2401

---

What is supporting issues GL AP and AR?

2561

---

what are the API of GL,PO,AP

2269

---

what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?

2216

---

What is the sql query to find the employee who has Nth maximum salary?

5331

---