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

  • Interview Candidate
  • 7
  • 2303

Showing Answers 1 - 7 of 7 Answers

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

  Was this answer useful?  Yes

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'

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions