Home » RDBMS Server » Server Administration » Schema creation
Schema creation [message #221644] Tue, 27 February 2007 21:57 Go to next message
rao_papa
Messages: 6
Registered: December 2006
Location: Hyderabad
Junior Member
Hi..


i have been working has oracle developer..today i want to create a schema in my database....but creating schema is a DBA activity...i don't know anything about DBA activities...what are steps i have to take before going to create schema..please let me know.


Paparao
Re: Schema creation [message #221649 is a reply to message #221644] Tue, 27 February 2007 22:23 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
If you are unwilling or incapable of using GOOGLE, then you are not qualified to create a schema!
From GOOGLE -> Results 1 - 10 of about 1,190,000 for oracle create schema.
Re: Schema Creation [message #221650 is a reply to message #221644] Tue, 27 February 2007 22:23 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Do NOT multipost/cross post!
Re: Schema Creation [message #221666 is a reply to message #221644] Wed, 28 February 2007 00:11 Go to previous message
zafarkarachi
Messages: 29
Registered: November 2006
Location: Karachi Pakistan
Junior Member
Hi

if you are using oracle 9i then

First connect as

sys/oracle@yourservicename as sysdba


yourservicename may be your db name because db name and service
name may be the same.

then at sql prompt

grant dba to abc identified by xyz

where dba is a default role to make your schema a dba

abc is username
xyz is password

Hope it helps.

Zafar Iqbal
Karachi.




Previous Topic: Buffer setting in Job Scheduler?
Next Topic: Oracle OS Question: SolarisX86 or RH Linux?
Goto Forum:
  


Current Time: Thu Dec 05 17:14:10 CST 2024