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

When the procedures or packagess become invalidate

3 Answers   TCS,

---

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

0 Answers   HCL,

---

what are the advantages of Oracle over other databases..? please give me reply...

2 Answers  

---

i want to know about the javaBean.what is its purpose and how it can use in Forms.

0 Answers   Logisoft,

---

What is Virtual Memory?

1 Answers  

---

How can you rebuild an index?

1 Answers  

---

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

1 Answers  

---

What is an Oracle database Full Backup?

0 Answers  

---

Why we are using primary key and foreign key in oracle and difference between primary key and foreign key?

1 Answers  

---

Can you explain how to adjust the amount of advance already received against an invoice? : oracle accounts receivable

0 Answers  

---

HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?

0 Answers  

---

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

0 Answers   Telesis,

---