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

How to update the simple views?give me example?if the table having 100 records and created a view on this table. if i can update the table then how to update the views

2 Answers   Cap Gemini, Syntel,

---

pl help me, i want oracle HRMS training institute address,in chennai

8 Answers  

---

hi iam looking for HRMS(functional) training inst or person in hyderbad. plz help me its urgent

1 Answers  

---

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.

0 Answers   Wipro,

---

while creating requisitions i am unable to see the list of organisation can anyone help me out ?

0 Answers  

---

A Table has 10,000 records,How can i get latest 10 dates from the table.so that i can only store those 10 records in to my Resultset Object,to reduce load on my app?

7 Answers   TCS,

---

Whats the purpose of using Nextval while creating the sequence.

2 Answers   HCL,

---

Give the stages of instance startup to a usable state where normal users may access it.

1 Answers  

---

What is store procedure?and how do u take the values from database and run in scripts?

2 Answers   Polaris,

---

Explain accounting for invoice in advance and arrears. : oracle accounts receivable

0 Answers  

---

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

0 Answers  

---

What is Tax Categories?

0 Answers  

---