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


Please Help Members By Posting Answers For Below Questions

Explain the payment term in ar. : oracle accounts receivable

621


WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?

1496


IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?

1622


I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5

2056


Give two methods you could use to determine what DDL changes have been made.

6026






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

1768


Is there any link between pr form(purchse requisition)and po form(purchase order)

2145


Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable

1243


I need a Technical evaluation between Oracle and SAP ? please do a need ful.

1492


can we use lexical perameter in oracle plsql if yes how

1826


What view would you use to determine free space in a tablespace?

1783


What is the difference between conversions and interfaces? : oracle accounts receivable

654


what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

1833


1. What is PO rate variance gain and loss?

2315


what are the API of GL,PO,AP

1779