SWITCH TO A NEW UNDO TABLESPACE

SWITCH TO A NEW UNDO TABLESPACE AND DROP OLD UNDO TABLESPACE

sqlplus "/ as sysdba"

SQL> show parameter undo_tablespace

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
undo_tablespace                      string      UNDOTBS1


SQL> create undo tablespace undo2
  2  datafile 'c:\oracle\oradata\ORCL\undo2.dbf'
  3  size 10m autoextend on ;

Tablespace created.

SQL> alter system set undo_tablespace=undo2 ;

System altered.

SQL> show parameter undo_tablespace

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
undo_tablespace                      string      UNDO2


SQL> drop tablespace undotbs1 ;

Tablespace dropped.

SQL> create pfile from spfile ;

File created.


-- FOR WINDOWS INSTALLATION
SQL> shutdown immediate ;
Database closed.
Database dismounted.
ORACLE instance shut down.

-- DROP THE DATAFILE ASSOCIATED WITH THE 
-- OLD UNDO TABLESPACE ON WINDOWS. 

SQL> startup
ORACLE instance started.
....
Database opened.

SQL> show parameter undo_tablespace ;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
undo_tablespace                      string      UNDO2

CONFIGURE APEX 3.0 ON ORACLE 11g

CONFIGURE APEX 3.0 ON ORACLE 11g

1) cd $ORACLE_HOME/apex
2) sqlplus / as sysdba 
3) @apxconf
4) Enter Admin password
5) Alter user anonymous account unlock;

CONFIGURE the HTTP port

1) Connect as sys and CALL dbms_xdb.setHttpPort(80) ; 
2) ALTER SYSTEM REGISTER ; 

OTHERS

1) Look of the port for HTTP 
   SELECT dbms_xdb.getHttpPort FROM DUAL ;
OR 
2) lsnrctl status 

RETURNING Clause with BULK COLLECT

DECLARE
  TYPE Table_Emp_t IS TABLE OF Emp%ROWTYPE;
  Emp_Pltbl Table_Emp_t;
BEGIN
  DELETE FROM Emp2;
  COMMIT;
  DELETE FROM Emp RETURNING 
    Empno, 
    Ename, 
    Job, 
    Mgr, 
    Hiredate, 
    Sal, 
    Comm, 
    Deptno 
      BULK COLLECT INTO Emp_Pltbl;
  ROLLBACK;
  Dbms_Output.Put_Line(Emp_Pltbl.COUNT);
  FORALL i IN 1 .. Emp_Pltbl.COUNT
    INSERT INTO Emp2 VALUES Emp_Pltbl (i);

  COMMIT;
END;
/

SELECT * FROM Emp2;