Home » Applications » Oracle Fusion Apps & E-Business Suite » how can I setup my dba for oracle 10g ?
how can I setup my dba for oracle 10g ? [message #182256] Fri, 14 July 2006 00:44 Go to next message
arasharash
Messages: 6
Registered: June 2006
Junior Member
Hi ,
I have installed oracle 10g , but how should I setup my dba ??

thanks

Report message to a moderator

Re: how can I setup my dba for oracle 10g ? [message #182287 is a reply to message #182256] Fri, 14 July 2006 02:59 Go to previous messageGo to next message
pbusolo
Messages: 4
Registered: July 2006
Junior Member
hi
As per what i get from ur request....i suggest you open the pl/sqlplus login, login with username:sysdba password:*****(use the one you set while installing)

you can then create a user with dba role by following this sql statements

SQL> CREATE USER yourname IDENTIFIED BY yourpassword;

SQL> GRANT DBA TO yourname;


you can then exit and try loggin in ...

Report message to a moderator

Re: how can I setup my dba for oracle 10g ? [message #182464 is a reply to message #182287] Sat, 15 July 2006 03:17 Go to previous message
arasharash
Messages: 6
Registered: June 2006
Junior Member
Hi,

what I mean , is , I want to make (create) a data base , thru oracle 10g, and put few tables in it (like what u have seen in access.
hope this much helps and sorry about my first question that u had problem w it.
thanks again

Report message to a moderator

Previous Topic: CASCADE FUNCTION IN PO
Next Topic: DROP SHIPMENT
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jun 29 05:18:55 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.