Interested to Buy Any Domain ? << Click Here >> for more details...
how to create an user in oracle 10g.please give me an example..
- 1 Answers
- 4926 Views
- I also Faced
- E-Mail Answers
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 |
Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha
HOW SHALL WE DIFFERENTIATE BETWEEN PRIMARY KEY AND FORIEGN KEY?
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
0 Answers Pathway Technologies,
deference between & and &&
IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?
what is difference between inner join & nested query or subqueries
what is the link between suppliers and banks in ap module in oracle apps? And also query?
How would you determine what sessions are connected and what resources they are waiting for?
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?
Explain prerequisites and post activities of oracle database installation
TILL WHAT LEVEL OF SECURITY BO SUPPORTS?
What is the use of lockboxes? : oracle accounts receivable
Oracle General 
