how to create an user in oracle 10g.please give me an example..



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

Post New Answer

More Oracle AllOther Interview Questions

what is semphore explian it?

0 Answers   IBM,


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

0 Answers  


types of receipts and detail desription about recipts and tables effected by receipts?

0 Answers  


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

0 Answers  


what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?

0 Answers   HP,






how can we send a concurrent program output to the clients through mail or fax give me example.

1 Answers   Cap Gemini,


How many segment are present in Oracle Manufacturing

0 Answers   Oracle,


how can we add a field to the oracle standard forms through Form Persanlization or custom.pll

0 Answers   TCS,


What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable

0 Answers  


You have just compiled a PL/SQL package but got errors, how would you view the errors?

1 Answers  


key flexfield structure

0 Answers   Infosys,


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

2 Answers   Cap Gemini, Syntel,


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)