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 background process refreshes materialized views?

1 Answers  

---

Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha

0 Answers  

---

what is shared memory?

1 Answers   IBM,

---

What is auto invoicing? Explain : oracle accounts receivable

0 Answers  

---

Hi I am searching for best oracle Apps institute? Please tel me which is best institute in hyderabad I am working in developer 6i....

2 Answers   Ion Exchange,

---

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

0 Answers   HP,

---

Explain the process of recievables in oracle financials. : oracle accounts receivable

0 Answers  

---

What view would you use to determine free space in a tablespace?

0 Answers  

---

What is db_recovery_file_dest in oracle? When do you need to set this value?

0 Answers  

---

Can we modify approve purchase order?if yes what is navigation?

0 Answers   L&T,

---

What is the architectural difference between Oracle and SQL Server 2000? If I have 100 databases, how many instances get created when you use Oracle and how many get created when you use SQL Server?

2 Answers   CTS,

---

how can it possibble to see the report output in excel sheet in oracle applications

4 Answers   Oracle, Wipro,

---