tag:blogger.com,1999:blog-2807785752181271137.post8300292550023153908..comments2024-03-06T12:33:57.350+01:00Comments on Damir Vadas, Oracle as I learned: Reinstall Apex (without loosing data)Damir Vadashttp://www.blogger.com/profile/15963017378937428976noreply@blogger.comBlogger9125tag:blogger.com,1999:blog-2807785752181271137.post-57045262022621101542020-12-15T20:51:53.076+01:002020-12-15T20:51:53.076+01:00You're welcome.You're welcome.Damir Vadashttps://www.blogger.com/profile/15963017378937428976noreply@blogger.comtag:blogger.com,1999:blog-2807785752181271137.post-61143094357693358272016-07-25T21:03:00.042+02:002016-07-25T21:03:00.042+02:00Saved me more than 3 times. made my week :-)Saved me more than 3 times. made my week :-)Etay Gudai - Oracle Israelhttps://www.blogger.com/profile/14316771717388275941noreply@blogger.comtag:blogger.com,1999:blog-2807785752181271137.post-62708718978815528972015-05-22T09:13:26.252+02:002015-05-22T09:13:26.252+02:00Glad to help you.Glad to help you.Damir Vadashttps://www.blogger.com/profile/15963017378937428976noreply@blogger.comtag:blogger.com,1999:blog-2807785752181271137.post-36944214615047890022015-05-22T09:10:07.312+02:002015-05-22T09:10:07.312+02:00You made my day. ThanksYou made my day. ThanksSher Alihttps://www.blogger.com/profile/06449398423711938546noreply@blogger.comtag:blogger.com,1999:blog-2807785752181271137.post-82430623593585899442012-10-30T18:38:46.726+01:002012-10-30T18:38:46.726+01:00This is not important in this case. I wanted to sa...This is not important in this case. I wanted to say something else.<br />I wanted to show how to repeat installation of Apex 4.2 and do not loose data stored from previous installation.<br />Mine approach allow to repeat THE SAME installation n times.<br />I see that I wasn't clear enough ...<br />8(Damir Vadashttps://www.blogger.com/profile/15963017378937428976noreply@blogger.comtag:blogger.com,1999:blog-2807785752181271137.post-5682852340320312592012-10-30T17:59:12.875+01:002012-10-30T17:59:12.875+01:00Eddie just wanted to tell you that apxremov.sql is...Eddie just wanted to tell you that apxremov.sql is NOT the right way to cleanup your old apex version.<br />From the documentation:<br />=> Remove Prior Oracle Application Express Installations<br />SQL> CONNECT SYS as SYSDBA<br /> SELECT username<br /> FROM dba_users <br /> WHERE (username LIKE 'FLOWS_%' OR USERNAME LIKE 'APEX_%') <br /> AND USERNAME NOT IN (<br /> SELECT 'FLOWS_FILES' <br /> FROM DUAL <br /> UNION <br /> SELECT 'APEX_PUBLIC_USER' FROM DUAL <br /> UNION<br /> SELECT SCHEMA s <br /> FROM dba_registry<br /> WHERE comp_id = 'APEX');<br /><br />this gives you => APEX_040000<br />then issue:<br />DROP USER APEX_040000 CASCADE;<br />EXEC DBMS_NETWORK_ACL_ADMIN.DELETE_PRIVILEGE('power_users.xml', 'APEX_040000');<br />H.<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2807785752181271137.post-58060521680880411392012-10-26T07:38:16.711+02:002012-10-26T07:38:16.711+02:00Eddie, I do not follow you but I think you didn...Eddie, I do not follow you but I think you didn't understand the point.<br />Please read first paragraph which tells what I have deleted.<br />And last in which other case this workaround is working.<br />Rg<br />DamirDamir Vadashttps://www.blogger.com/profile/15963017378937428976noreply@blogger.comtag:blogger.com,1999:blog-2807785752181271137.post-6245996551188989032012-10-25T23:05:31.953+02:002012-10-25T23:05:31.953+02:00You can avoid all the problems if you only remove ...You can avoid all the problems if you only remove the old schema (APEX_040100) with an:<br /><br />drop user apex_040100 cascade;<br /><br />The script you run to de-install is for remove completly Apex not only the old schema.Anonymoushttps://www.blogger.com/profile/07621746136457893751noreply@blogger.comtag:blogger.com,1999:blog-2807785752181271137.post-18685877368908768822012-10-19T19:56:52.591+02:002012-10-19T19:56:52.591+02:00This saves me-thx a lotThis saves me-thx a lotAnonymousnoreply@blogger.com