Tags » 11g

How to rename an Oracle schema without exporting and importing all schema data

If you need to rename an Oracle database schema and search for this on the web you will note that:

  • there is no SQL statement to rename an schema … 2,015 more words
  • 12c

    EO User Interface(UI) Hints

    We can define how the EO attributes should be displayed when they get bound to a page. These hints can be over-ridden when designing the UI. 71 more words


    R12 Take Aways and Warnings, Part 3 (Java Clients, Dataguard with editioning, logs, crons and the Workflow Notification Mailer)

    More R12.2 War Stories

    I thought I’d go back to my R12.2 war stories today.  To be honest, I still have plenty to talk about even after this post, but a journey of a thousand miles begins with one step, right? 1,549 more words


    Weekly script #3 unix_usr.sql

    I use this one all the time. You have a high usage unix PID that is an Oracle Process. The script will take your defined pid and lookup the relating SQL and database user details to help you figure out the root cause. 770 more words


    Default value for an EO Attribute

    The attributes of an EO can be seen by opening the EO and selecting the Attributes tab. A new attribute can be added by clicking the button with a green color plus sign. 113 more words


    Free Demo I: Oracle ADF 11g Training: Tuesday, February 24 at 08:00 AM India Time

    S&M Consultants is pleased to invite you to join the upcoming Online Session for Oracle ADF Training.

    To attend the class please login at : … 23 more words