APPSDBA Data Lake

  java   oracle.jrad.tools.xml.importer.JPXImporter   $HOME/kturley/ XXCUST_projects_list.jpx   -username apps -password xxxx -dbconnection “(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST= hostname.oracle.co.uk)(PORT=1551))(CONNECT_DATA=(SID=XXXXX )))”  Make sure you specify the correct values for  1. Path of you jpx file  2. apps password  3. host name  4. port  5. database SID  Finally restart the webserver so that you can see your changes in the application  $INST_TOP/admin/scripts/ adoacorectl.sh  stop $INST_TOP/admin/scripts/ adoacorectl.sh  start  

Can I flush the Undo tablespace by any chance... ? You don't need to flush any thing from the undo tablespace. It will reuse the undo data automatically. You can create a new undo tablespace and make it active for your database. Later on drop your old undo tablespace. UNDO_RETENTION time undo tablespace is filled and any query fails, then if another query is going to do a DML and tries to use UNDO segments then, I think that will also fail because of unavailability of UNDO SEGMENTS.. > create undo tablespace undotbl_new datafile size 1m; Tablespace created. > alter system set undo_tablespace = undotbl_new scope=both; System altered. > drop tablespace undotbs; Tablespace dropped.