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 is autocashrule set? : oracle accounts receivable

0 Answers  

---

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

0 Answers  

---

How to move the data from one flatfile to multiple staging tables?give me some examples? for example in po interface one flat file is there and multiple staging tables are there how can move it?please give me answer for this question?

0 Answers   Cap Gemini,

---

What is the difference between the SQL*Loader and IMPORT utilities?

1 Answers  

---

What is the mandatory setup in cyclecount ?

0 Answers   Oracle,

---

what ASIS BUSINESS PROCESS IN ORACLE FINANCE

0 Answers  

---

Name a tablespace automatically created when you create a database.

3 Answers   HCL,

---

What command would you use to encrypt a PL/SQL application?

1 Answers  

---

Can we get the deleted Record again if the delete transaction has been committed.

4 Answers  

---

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

0 Answers  

---

How would you go about increasing the buffer cache hit ratio?

0 Answers  

---

What is database schema?

4 Answers   Infosys,

---