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 |
i am pursuing mca and i want to do oracle apps technical in hydrabad, plz guide me tne best institue in hydrabad those have excellent knowledge in oracle apps.
what are important reports in HRMS,GL,AP,AR in oracle apps?
3 Answers IBM, Pathway Technologies, Satyam, Techtimer, Wipro,
Describe the P2P cycle ?
how to display last 5 letters from a name (take emp table ename )
I am Bsc Computer Science Graduate, I have good knowledge in SQL 7.0, Can I go for Oracle APPS course please suggest me the answer
What is the meaning of "Modulus" and "Alignment" in a datafile. Data file might be from any database. Data file is created through unloading data from a table. So, while loading this data into my table, I need to use these keywords. Could any one can help me regarding this?
A scenario for amount correction & how to use amount correction functionality in AP invoices
difference of using cursor for loop and open,fetch,close.which one is better
What do you mean by hz_ in customer tables? : oracle accounts receivable
What is the Symbol use for Inner Join
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?
Difference between negative and positive adjustments : oracle accounts receivable