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

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

10 Answers   TCS,

---

Describe what redo logs are.

1 Answers  

---

which gives Oracle R12 Financial training in delhi please give me answer its urgent?

0 Answers  

---

How would you determine who has added a row to a table?

0 Answers  

---

Where in the Oracle directory tree structure are audit traces placed?

0 Answers  

---

Explain the payment term in ar. : oracle accounts receivable

0 Answers  

---

wht r the base tables & primary key for BOM& WIP modules

1 Answers   Satyam,

---

Name two files used for network connection to a database.

1 Answers  

---

What is the Query Optimizer. How you optimize your qeury.

2 Answers   Ericsson,

---

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 Person_Type_id column in the per_all_people_f and per_person_type_usages_f

0 Answers  

---

can u pls share responsibilities for production how to environment in odi?and how to generate report ?

0 Answers  

---