How to Delete All Objects for a User in Oracle

Detail

Normally, it is simplest to drop and add the user. This is the preferred method if you have system or sysdba access to the database.
If you don't have system level access, and want to scrub your schema, the following sql will produce a series of drop statments, which can then be executed.

select 'drop '||object_type||' '|| object_name|| DECODE(OBJECT_TYPE,'TABLE',' CASCADE CONSTRAINTS;',';')
from user_objects

Then, I normally purge the recycle bin to really clean things up. To be honest, I don't see a lot of use for oracle's recycle bin, and wish i could disable it... but anyway:

purge recyclebin;

This will produce a list of drop statements. Not all of them will execute - if you drop with cascade, dropping the PK_* indices will fail. But in the end, you will have a pretty clean schema. Confirm with:

select * from user_objects

Source: http://jmatrix.net/dao/case/case.jsp?case=7F000001-E22F2B-10CCCCB2924-862

Change Oracle XE (licence) homepage

The default homepage for Oracle XE is a licence page.
This file is located at the server and is name its index.html

To change this file you must...
1) Open the webdav directory where the oracle files are located as a web folder.

2) Authenticate as the user database system.

3) Change the index.htm file

Sourceforge

Oracle Application Express Apps no Sourceforge

Links Úteis

Oracle Application Express (APEX), formerly called HTML DB

Dietmar Aust blogspot

Oracle XE: Create and Authorize DAD's

Conn sys
*******************

BEGIN
Dbms_Epg.create_dad('MRK', '/mrk/*');
END;
/

begin
dbms_epg.set_dad_attribute('MRK', 'database-username', 'MRK');
end;
/

BEGIN
dbms_epg.authorize_dad('MRK');
END;
/

begin
dbms_epg.set_dad_attribute('MRK', 'default-page', 'cb_marca');
end;
/



Conn mrk: o próprio tb tem de autorizar a visualização
******************

BEGIN
dbms_epg.authorize_dad('MRK');
END;
/

Oracle XE: Change HTTP port

snrctl stop

SQLPLUS /NOLOG

CONNECT SYSTEM/password

EXEC DBMS_XDB.SETHTTPPORT(80);

lsnrctl start

Oracle XE

Um sitio para partilhar informação sobre Oracle XE...