(Solved) : Follow Instructions Listing 6 2 Page 121 Create Destroy Database Create New Database Need Q34929222 . . . .

Follow the instructions in Listing 6-2 on page 121 to create anddestroy a database. Before you create a new database, you will needa profile (PFILE) named initTest.ora in the directory from whichyou are running sql*plus (or specify the entire path with the filename). This file contains the single line db_name=TEST. This willcreate the simplest database possible. You also need to SETORACLE_SID=TEST at the command prompt, before running SQLPLUS / assysdba. You will know you started the correct instance if it says,”Connected to an idle instance.” Don’t forget to SPOOL

Expert Answer

An answer will be send to you shortly.