Oracle Database

  • Download M7script.sql to c:\cis4210.
  • Start sqlplus sys/Oracle11 as sysdba.
  • SPOOL c:\cis4210\M7spool.txt
  • START c:\cis4210\M7script.sql
  • DESC SCOTT.EMP (a table belonging to the user SCOTT.)
  • Create a new table called SCOTT.EMP_RANGE that contains the same columns as the employee table. The partition key is the EMPNO column, and there should be five partitions, all located in the USERS tablespace. Assume that the values in EMPNO start at one, reach 100,000 and are distributed evenly. Remember, EMPNO needs to be adjusted to hold 100000 records.

Submit your text document with the file name c:\cis4210\M7spool.txt .


Get Help With a similar task to - Oracle Database

Login to view and/or buy answers.. or post an answer

Related Questions

Similar orders to Oracle Database
66
Views
0
Answers
JDBC GUI with two factory classes and a trigger.

Congratulations, you know run a summer camp for kids.  Create a table named CAMPERS on your Oracle

account that has these fields:

·        

ID

·     &nbs...