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

Manikandan

• Sep 22nd, 2006

 

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

dl_mstr

 Profile Answers by dl_mstr 

• Feb 12th, 2008

 

To run script
SQl> @ C:script.txt

basmgokul

 Profile Answers by basmgokul 

• Apr 3rd, 2008

 

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'