Basics - i want to try create the database from my script which i made.can help me how to run a script. can e

GeekInterview.com > Interview Questions > Oracle > Basics

Go To First | Previous Question | Next Question

Basics | Question 23 of 49

i want to try create the database from my script which i made.
can help me how to run a script. can explain me step by step because i am a starter.

thank's

Total Answers and Comments: 3

Last Update: April 03, 2008 Asked by: agusprg

Sponsored Links

Best Rated Answer

—

Submitted by: basmgokul

Hi,

Step 1: save your script as .sql format.
Step 2: to run your script, follow this

SQL> @'pathname'

assume your script db.sql was saved in c:datascript, then

ex:
SQL>@'c:datascriptdb.sql'

Above answer was rated as good by the following members:
subajay

September 22, 2006 05:48:32

Manikandan

RE: i want to try create the database from my script w...

CREATE DATABASE testdb DATAFILE 'testdb_system' SIZE 10M LOGFILE GROUP 1 ('testdb_log1a' 'testdb_log1b') SIZE 400K GROUP 2 ('testdb_log2a' 'testdb_log2b') SIZE 400K;other things remain constant.The SYSTEM tablespace is 10 MB database does not overwrite any existing control files specified in the parameter file

Is this answer useful? Yes | No

February 12, 2008 20:32:10

dl_mstr

Member Since: November 2007 Contribution: 26

RE: i want to try create the database from my script which i made.can help me how to run a script. can explain me step by step because i am a starter.thank's

To run script
SQl> @ C:script.txt

Is this answer useful? Yes | No

0 1

Overall Rating: -1

April 03, 2008 02:25:41

basmgokul

Member Since: April 2008 Contribution: 1

RE: i want to try create the database from my script which i made.can help me how to run a script. can explain me step by step because i am a starter.thank's

Hi

Step 1: save your script as .sql format.
Step 2: to run your script follow this

SQL> @'pathname'

assume your script db.sql was saved in c:datascript then

ex:
SQL>@'c:datascriptdb.sql'

Is this answer useful? Yes | No

1 0

Overall Rating: +1

Go To Top

User Name		Remember Me?
Password

Question Bank