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

Are These Dff's Flexible?

0 Answers   Oracle,

---

What are the main diff. between oracle 7.3 and oracle 8i?

1 Answers  

---

default triggers available for reports

0 Answers  

---

what is difference between inner join & nested query or subqueries

0 Answers  

---

i am pursuing mca and i want to do oracle apps technical in hydrabad, plz guide me tne best institue in hydrabad those have excellent knowledge in oracle apps.

0 Answers  

---

What is the mandatory setup in cyclecount ?

0 Answers   Oracle,

---

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

0 Answers  

---

HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?

0 Answers  

---

What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?

0 Answers  

---

what is semphore explian it?

0 Answers   IBM,

---

what ASIS BUSINESS PROCESS IN ORACLE FINANCE

0 Answers  

---

You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?

1 Answers  

---