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

deference between & and &&

2 Answers   Mphasis,

---

i have marks in table,how to find total?

1 Answers  

---

What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable

0 Answers  

---

Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.

1 Answers   HCL,

---

what are basic modules required to implement oracle application in any oraganisation?

0 Answers  

---

How to update the simple views?give me example?if the table having 100 records and created a view on this table. if i can update the table then how to update the views

2 Answers   Cap Gemini, Syntel,

---

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

0 Answers  

---

What is the Symbol use for Inner Join

1 Answers   Oracle, TCS,

---

key flexfield structure

0 Answers   Infosys,

---

what is difference between inner join & nested query or subqueries

0 Answers  

---

Give the two types of tables involved in producing a star schema and the type of data they hold.

1 Answers  

---

How do you resize a data file?

2 Answers  

---