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 |
what is semphore explian it?
IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?
types of receipts and detail desription about recipts and tables effected by receipts?
Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable
what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?
how can we send a concurrent program output to the clients through mail or fax give me example.
How many segment are present in Oracle Manufacturing
how can we add a field to the oracle standard forms through Form Persanlization or custom.pll
What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable
You have just compiled a PL/SQL package but got errors, how would you view the errors?
key flexfield structure
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