Can someone please guide me trough this assigment. Thank you Written Assignment

Question

Can someone please guide me trough this assigment. Thank you

Written Assignment

Download S5script.sql   to c:cis421b.
Start sqlplus system/Oracle11 as sysdba.
SPOOL c:cis421bs5spool.txt
START c:cis421bS5script.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 c:cis421bs5spool.txt to the form inside this folder.

So, I have a trouble creating that table what I should insert to have it created?

QL SPOOL c:cis421bs5spool.txt QL> ALTER USER SCOTT 2 DEFAULT TABLESPACE USERS 3 QUOTA 1eM ON USERS 4 ser altered QL> DESC SCOTT. EMP Name Null? Type NOT NULL NUMBER (4) EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO VARCHAR2 ( 1 ) VARCHAR2 (9) NUMBER(4) DATE NUMBER(7,2) NUMBER(7,2) NUMBER(2) SQL>

Explanation / Answer

Please find the answer below:

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---