Answer Posted / 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

HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..

2561

---

Differentiate between writeoff and receipt writeoff. : oracle accounts receivable

1409

---

i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks

2332

---

How to clone the database using RMAN back

2310

---

PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE

2280

---

My requirement is like in database some defects are present and i need to clean them.To be brief for example every employee should have active assigments.So for those records which are not having status as active or null ,i need to update the roecords using API with the correct value. Client will provide a flat file for the records whch are defected.So i need to run the API for those records (flat file)and update the data in database. So my question is how to handle this requirement.Is there any existing API for this purpose?If yes then please send me the NAME. How to update the records in the database using flatfile. Any pointer will be appreciated.Thanks in advance.

2262

---

difference of using cursor for loop and open,fetch,close.which one is better

1861

---

where the dff data will be stored

2537

---

what ASIS BUSINESS PROCESS IN ORACLE FINANCE

2324

---

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

1165

---

What is supporting issues GL AP and AR?

2614

---

What is the disk migration? what is the steps involved in oracle disk migration?

1266

---

I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5

2558

---

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

2261

---

1. What is PO rate variance gain and loss?

3008

---