how to create an user in oracle 10g.please give me an example..
Answer Posted / 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 |
Post New Answer View All Answers
Explain the payment term in ar. : oracle accounts receivable
WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?
IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?
I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5
Give two methods you could use to determine what DDL changes have been made.
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
Is there any link between pr form(purchse requisition)and po form(purchase order)
Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable
I need a Technical evaluation between Oracle and SAP ? please do a need ful.
can we use lexical perameter in oracle plsql if yes how
What view would you use to determine free space in a tablespace?
What is the difference between conversions and interfaces? : oracle accounts receivable
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
1. What is PO rate variance gain and loss?
what are the API of GL,PO,AP