Applying It

Independent Exercise 1:

• Export the SCOTT schema.
  
  
• Drop the SCOTT.EMP table.
  
  
• Import just the SCOTT.EMP table.
  
  

Independent Exercise 2:

• Create a SQL*Loader control file for EMP.
  
  
• Delete all the rows in EMP.
  
  
• Use SQL*Loader to put data into the SCOTT.EMP table.
  
  

Independent Exercise 3:

• Create a simple data file using ':' as field delimiters.
  
  
• Create an External Table based on this simple data file.
  
  
• Query your simple data using the External Table.