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

PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE

2208

---

How do you create a credit note against an invoice? : oracle accounts receivable

1077

---

HOW TO SPOT AHIERARCHY?

2285

---

QUESTION IS THAT DURING UPLOADING DATA IN PROD SERVER,OUR EQUIPMENT TAG NUMBERS ARE NOT MATCHING WITH SAP TAG NUMBERS SO DUE TO THIS WE ARE FACING PROB, BECAUSE WHENEVER ALARM IS COMING FROM SCADA DUE MISMATCH THE NOTIFICATION IS NOT CREATED IT IS GIVING ERROR. PLEASE SUGGEST THE METHOD SO THAT THE TAG NUMBERS OF BOTH (SCADA EQUIPMENT AND SAP EQUIP) SHOULD CONCIDE.OTHERWISE WE HAVE TO GO FOR LONG PROCESS EITHER BY INTERFACE TABLE OR BY EXPORTING ALL DATA AND MAKING RIGHT CHANGES.DO YOU HAVE ANY SHORTCT METHOD PL WRITE ME. THANKS

2058

---

we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.

2501

---

Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.

2325

---

how to write customizations in po

1606

---

where the dff data will be stored

2422

---

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

1120

---

How to clone the database using RMAN back

2217

---

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

1216

---

what are the tools used for oracle 10g in real time.

2433

---

please send me oracle pl/sql exp resume. and also faqs...

2485

---

What is the importance of batch source set up in ar? : oracle accounts receivable

1253

---

can we use lexical perameter in oracle plsql if yes how

2305

---