Home » RDBMS Server » Server Administration » Create Database
Create Database [message #311745] Sun, 06 April 2008 08:37 Go to next message
ORAGENASHOK
Messages: 238
Registered: June 2006
Location: Chennai
Senior Member
Hi,

I want to create a database from scott/tiger login
if i create any database with scott/tiger login is any data can get lost in the current datafiles?

Given below is my version details

SQL*Plus: Release 9.0.1.0.1 - Production on Sun Apr 6 18:55:29 2008

(c) Copyright 2001 Oracle Corporation. All rights reserved.


Connected to:
Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production
With the Partitioning option
JServer Release 9.0.1.1.1 - Production

SQL>
Re: Create Database [message #311750 is a reply to message #311745] Sun, 06 April 2008 09:03 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
I want to create a database from scott/tiger login

You can't.

Regards
Michel
Re: Create Database [message #311755 is a reply to message #311750] Sun, 06 April 2008 09:49 Go to previous messageGo to next message
ORAGENASHOK
Messages: 238
Registered: June 2006
Location: Chennai
Senior Member
Michel

Please explain why i can't create a database from scott/tiger login and also give me a guide how to create a new database with CREATE DATABASE command.

Re: Create Database [message #311756 is a reply to message #311745] Sun, 06 April 2008 09:54 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
>Please explain why i can't create a database from scott/tiger login
If you want to CREATE DATABASE, then no database exists.
If no database exists, then there is no scott/tiger login!

Do you even know what CREATE DATABASE does?
Re: Create Database [message #311810 is a reply to message #311756] Sun, 06 April 2008 23:12 Go to previous messageGo to next message
ORAGENASHOK
Messages: 238
Registered: June 2006
Location: Chennai
Senior Member
It will create a new database
Re: Create Database [message #311811 is a reply to message #311745] Sun, 06 April 2008 23:14 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
>It will create a new database
So proceed to do so or take the easy way out & use dbca utility.
Re: Create Database [message #311829 is a reply to message #311810] Mon, 07 April 2008 00:55 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
It will create a new database

What is a database for you?

Regards
Michel
Re: Create Database [message #311992 is a reply to message #311829] Mon, 07 April 2008 11:54 Go to previous messageGo to next message
ORAGENASHOK
Messages: 238
Registered: June 2006
Location: Chennai
Senior Member
A database is a structured collection of records or data that is stored in a computer system
Re: Create Database [message #311998 is a reply to message #311992] Mon, 07 April 2008 12:05 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No, this is a table.

Regards
Michel
Re: Create Database [message #311999 is a reply to message #311745] Mon, 07 April 2008 12:08 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
For what is worth in a recent thread on the ORACLE_L email list,
some folks claimed that the term DATABASE is not defined in the SQL Standards document.

We do know that Oracle's definition of "DATABASE" is different than Micro$oft's & MYSQL's definition.
Re: Create Database [message #312364 is a reply to message #311998] Tue, 08 April 2008 12:29 Go to previous messageGo to next message
ORAGENASHOK
Messages: 238
Registered: June 2006
Location: Chennai
Senior Member
can you please give me brief explanation about DATABASE or send me any reference document to know exact means of DATABASE and also their emifications
Re: Create Database [message #312365 is a reply to message #311745] Tue, 08 April 2008 12:39 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
http://download.oracle.com/docs/cd/B19306_01/server.102/b14196/instance001.htm#sthref215
Re: Create Database [message #312366 is a reply to message #312365] Tue, 08 April 2008 12:45 Go to previous messageGo to next message
ORAGENASHOK
Messages: 238
Registered: June 2006
Location: Chennai
Senior Member
can we view that database table and where
Re: Create Database [message #312372 is a reply to message #311745] Tue, 08 April 2008 13:03 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
I guess ORAGEN is your company's name.
Are you just playing around or is it a real question?
Re: Create Database [message #312373 is a reply to message #312372] Tue, 08 April 2008 13:08 Go to previous messageGo to next message
ORAGENASHOK
Messages: 238
Registered: June 2006
Location: Chennai
Senior Member
No i am not playing ,if i make any mistake please forgive me i am very much new to ORACLE thats why i put this question please explain?

I want know top to bottom about ORACLE ARCHI and their process.
Re: Create Database [message #312374 is a reply to message #311745] Tue, 08 April 2008 13:10 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
>I want know top to bottom about ORACLE ARCHI and their process.
visit http://tahiti.oracle.com & start reading.
Come back after reading the whole collection for v10.2 with any more questions that were not answered in the Fine Manuals.
Re: Create Database [message #312375 is a reply to message #312372] Tue, 08 April 2008 13:13 Go to previous messageGo to next message
ORAGENASHOK
Messages: 238
Registered: June 2006
Location: Chennai
Senior Member
According to the document given by anacedent it is nothing but the collection of operating system files containing data and ORACLE structural information.



And for my previous question Michel Cadot toldme DATABASE is a table that why i asked that question
Re: Create Database [message #312376 is a reply to message #311745] Tue, 08 April 2008 13:13 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
WHy 9.0.1?
DOWnload 10g
Re: Create Database [message #312377 is a reply to message #312373] Tue, 08 April 2008 13:14 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
First step (very first one) read Database Concepts

Regards
Michel
Re: Create Database [message #312378 is a reply to message #311745] Tue, 08 April 2008 13:15 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Quote:
A database is a structured collection of records or data that is stored in a computer system


This definition belongs to table.
Re: Create Database [message #312379 is a reply to message #312378] Tue, 08 April 2008 13:17 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Is this not what I said 25 hours ago?

Regards
Michel
Re: Create Database [message #312381 is a reply to message #311745] Tue, 08 April 2008 13:21 Go to previous message
varu123
Messages: 754
Registered: October 2007
Senior Member
Yes ofcourse,
I was responding to OP as he took your statement

Quote:
No, this is a table.


for database.
Previous Topic: How to know constraints
Next Topic: startup mount
Goto Forum:
  


Current Time: Thu Dec 08 02:25:08 CST 2016

Total time taken to generate the page: 0.07554 seconds