Avatar billede fredand Forsker
18. marts 2008 - 21:25 Der er 4 kommentarer og
2 løsninger

How to create a user or schema in Oracle 10g

Hello!

I try to set up a database in Oracle 10g.

I manage to create a "database" with:
Global Database Name: TEST.UTV.SE
SID: TEST1

Correct me if I'm wrong, but next step is to create a user/schema/tablespace, where I can create my database objects, right?

But I can not find where I create a user/schema in any of the apps that came with Oracle installation??

Because when I try to login with Toad I'm asked to fill in:
Database: TEST1
User/Schema: MY_TEST_SCHEMA
Password: MY_TEST_PASS

Earlier when I worked with Oracle, probably version 9i, I think I remember there was a program called "Enterprise Manager"
The only application I find after installing Oracle 10g that comes close to "Enterprise Manager" is "Database Configurtaion Assistant".
Perhaps I miss any application?

But If I check in: Oracle Universal Installer > Installed products ...I can find Oracle Enterprise Manager Console DB 10.2...

So if any one got a clue how to create a user/schema, please let me know.

Best regards
Fredrik
Avatar billede arne_v Ekspert
19. marts 2008 - 03:22 #1
I find it difficult to believe that there are no EMC in 10g. But I only have 9i installed
so I can not check.

Worst case must be doing it  the hard way.

SQL Plus !

http://www.psoug.org/reference/tablespaces.html
http://www.psoug.org/reference/user.html

and a bazillion other places.
Avatar billede holdam Nybegynder
19. marts 2008 - 08:42 #2
You will have to install the "Oracle Database 10g Client Release 2" to gain access to Enterprise Manager. It can be found here:

http://download.oracle.com/otn/nt/oracle10g/10201/10201_client_win32.zip (if you run Windows)

Oracle has split the installation files into two to be able to fit them in CDs...
Avatar billede fredand Forsker
20. marts 2008 - 19:38 #3
Hello Guys!

Thanks for your help.
I have not seen this before but in Oracle 10g you have an web-admin interface where you can add users and much more.

I insist, please give svar so I can reward you both.
Your comments are very appreciated!!

Best regards
Fredrik
Avatar billede arne_v Ekspert
20. marts 2008 - 19:57 #4
ok
Avatar billede holdam Nybegynder
21. marts 2008 - 12:36 #5
And ok from me as well
Avatar billede fredand Forsker
21. marts 2008 - 14:16 #6
Thanks mates!
Best regards
Fredrik
Avatar billede Ny bruger Nybegynder

Din løsning...

Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.

Loading billede Opret Preview
Kategori
Computerworld tilbyder specialiserede kurser i database-management

Log ind eller opret profil

Hov!

For at kunne deltage på Computerworld Eksperten skal du være logget ind.

Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.

Du kan også logge ind via nedenstående tjenester