User Name Password Register
DaniWeb IT Discussion Community
All
What is DaniWeb IT Discussion Community?
You're currently browsing the Oracle section within the Web Development category of DaniWeb, a massive community of 391,708 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,428 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Oracle advertiser:
Views: 897 | Replies: 6
Reply
Join Date: Aug 2007
Posts: 147
Reputation: tanha is an unknown quantity at this point 
Rep Power: 0
Solved Threads: 0
tanha tanha is offline Offline
Junior Poster

Database Creation problem in Oracle

  #1  
May 11th, 2008
Hallo everybody,
newly I installed OracleUnivEx 10g, and also I am able to connect to Oracle by its own Web-GUI, but the problem not recognising the MySQL commands like "create database "db_name"" and others like SELECT, INSERT, and ...

any idea please? how to create database in Oracle and modefy it...
AddThis Social Bookmark Button
Reply With Quote  
Join Date: Aug 2007
Posts: 147
Reputation: tanha is an unknown quantity at this point 
Rep Power: 0
Solved Threads: 0
tanha tanha is offline Offline
Junior Poster

Re: Database Creation problem in Oracle

  #2  
May 12th, 2008
Hi again,
I can create table, and insert data into the table, but I can not create database, and I dont know the tables I created is inside which database?

can any one please tell me How can I create database in Oracle?

thanks
Reply With Quote  
Join Date: Feb 2007
Location: Bangalore,India
Posts: 1,213
Reputation: debasisdas is an unknown quantity at this point 
Rep Power: 4
Solved Threads: 78
debasisdas's Avatar
debasisdas debasisdas is offline Offline
Nearly a Posting Virtuoso

Re: Database Creation problem in Oracle

  #3  
May 14th, 2008
Please do not try MySQL commands in SQL.

creation of database is diffent in oracle .
Refer to books/manual for details.
Share your Knowledge.
Reply With Quote  
Join Date: Feb 2007
Location: Bangalore,India
Posts: 1,213
Reputation: debasisdas is an unknown quantity at this point 
Rep Power: 4
Solved Threads: 78
debasisdas's Avatar
debasisdas debasisdas is offline Offline
Nearly a Posting Virtuoso

Re: Database Creation problem in Oracle

  #4  
May 14th, 2008
if you have oracle server installed in your system then it must be the default database name or the name you have choosen at the time of installation.

If you donot know the name of the database how you have connected to the server.

If using only username and password to login then check in the default database in your system.
Share your Knowledge.
Reply With Quote  
Join Date: Aug 2007
Posts: 147
Reputation: tanha is an unknown quantity at this point 
Rep Power: 0
Solved Threads: 0
tanha tanha is offline Offline
Junior Poster

Re: Database Creation problem in Oracle

  #5  
May 14th, 2008
I installed OracleXE 10g, and I have username and password, and I can do everything, table creation, view creation, deletion, updation and so on... but I can not create database, it mean s all those are done in the default database named XE.

BUT I like to have my own database and do something on that...
could you plz guide me through that... I read the manual but there mentioned about tablespace, and path and temp and something like these...
Reply With Quote  
Join Date: Nov 2004
Location: Netherlands
Posts: 5,646
Reputation: jwenting is a jewel in the rough jwenting is a jewel in the rough jwenting is a jewel in the rough jwenting is a jewel in the rough 
Rep Power: 18
Solved Threads: 191
Colleague
jwenting's Avatar
jwenting jwenting is offline Offline
duckman

Re: Database Creation problem in Oracle

  #6  
May 15th, 2008
XE supports a single database, which the installer creates.
That's the main limitation of the product, as is very well documented.

If you want more capabilities, you need the full Oracle 10g (or 11g) product, which is available for sale (or for qualifying people for free for test/eval/development purposes).
42 Private messages asking for help will be ignored
In the frozen land of Nador they were forced to eat Steve's iMinstrels, and there was much rejoicing.
Reply With Quote  
Join Date: Aug 2007
Posts: 147
Reputation: tanha is an unknown quantity at this point 
Rep Power: 0
Solved Threads: 0
tanha tanha is offline Offline
Junior Poster

Re: Database Creation problem in Oracle

  #7  
May 18th, 2008
Thanks for the information,
Then I can not find the one to be able to create databases and do some more options
Reply With Quote  
Reply

Only community members can participate in forum threads. You must register or log in to contribute.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 

DaniWeb Oracle Marketplace
Thread Tools Display Modes

Similar Threads
Other Threads in the Oracle Forum

All times are GMT -4. The time now is 2:59 am.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC