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

1. What is PO rate variance gain and loss?

0 Answers   Oracle,

---

what is different between inline query,subquery& corelated query?

8 Answers   Quest,

---

What is the difference between oracle media recovery and crash recovery?

0 Answers  

---

Should you take the backup of Logfiles if the database is running in ARCHIVELOG mode?

4 Answers  

---

How do you use trigger to create mutating state of table

2 Answers   TCS,

---

---

What is the technical flow associated with P2P or Procure to Pay cycle like the tables, APIs, concurrent programs involved in this cycle. Only technical please.

0 Answers   TCS,

---

What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable

0 Answers  

---

How can you rebuild an index?

1 Answers  

---

what is the difference between TRUNCATE and DELETE command in SQL

23 Answers   ICICI, Saama Tech, SkyTech, TCS,

---

Give two methods you could use to determine what DDL changes have been made.

1 Answers  

---

I have 3+ Years experience HR with Technical Recruitment Industry. Now i would like to learn oracle HRMS Models of all aspect. please suggest any one, which institution is best for oracle HRMS practical with real time teaching in Chennai, Tamilnadu. What are the basic stat up to learn Oracle HRMS with Core strongly?

1 Answers   Oracle,

---

Explain an ORA-01555

2 Answers  

---