Answer / 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 are the advantages of Oracle over other databases..? please give me reply...

2 Answers  

---

What Are Cross Validation & Adi?

0 Answers   Oracle,

---

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

0 Answers  

---

Name two files used for network connection to a database.

1 Answers  

---

Name three advisory statistics you can collect.

1 Answers  

---

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

0 Answers  

---

Give two examples of referential integrity constraints.

1 Answers  

---

how to replace not in with not exist?

0 Answers   IBM,

---

Describe what redo logs are.

1 Answers  

---

When a user process fails, what background process cleans up after it?

1 Answers  

---

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

0 Answers  

---

Differentiate between transaction type and transaction source? : oracle accounts receivable

0 Answers  

---