Usetutoringspotscode to get 8% OFF on your first order!

  • time icon24/7 online - support@tutoringspots.com
  • phone icon1-316-444-1378 or 44-141-628-6690
  • login iconLogin

Written assignment 6

Follow the instructions in Listing 6-2 on page 121 to create and destroy a database. Before you create a new database, you will need a profile (PFILE) named initTest.ora in the directory from which you are running sql*plus (or specify the entire path with the file name). This file contains the single line db_name=TEST. This will create the simplest database possible. You also need to SET ORACLE_SID=TEST at the command prompt, before running SQLPLUS / as sysdba. You will know you started the correct instance if it says, “Connected to an idle instance.”  Don’t forget to SPOOL c:cis4210M6spool.txt as soon as you sign into sql*plus.
Submit your text document with the file name c:cis4210M6spool.txt .

*I have attached a photo of the instructions in Listing 6-2 on pg 121.

You can leave a response, or trackback from your own site.

Leave a Reply

Powered by WordPress | Designed by: Premium WordPress Themes | Thanks to Themes Gallery, Bromoney and Wordpress Themes