how to create an user in oracle 10g.please give me an example..
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
| Is This Answer Correct ? | 1 Yes | 0 No |
Explain the payment term in ar. : oracle accounts receivable
What is mrc and what is its use? : oracle accounts receivable
What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable
please send me oracle pl/sql exp resume. and also faqs...
how to replace not in with not exist?
3. Steps in UAT?
1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count
How would you determine who has added a row to a table?
WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?
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
What command would you use to create a backup control file?
What is difference b/w Credit memo and Adjustment in AR.