Top Articles

How Oracle Stores Passwords

sdstuber06/09/2009, 12:00 AM

How Oracle Stores Passwords Sean D. Stuber 2009-06-09 Up to date through Oracle version 11g Overview: Many times a DBA may want to replicate a user from one system to another and migrate that same password,such as refreshing a production syste

Topic: Oracle DatabaseTags: Oracle, 10g, 11g, DBA_USERS, SYS.USER$, password, hash

Views: 22957Comments: 36

Connect by prior

ivostoykov02/12/2010, 12:00 AM

by Ivo Stoykov One of challenges in data digging is hierarchical data representation. Usually manipulating trees in relational database raises lots of questions and confusions. In following lines I’ll try to scatter the fog around this topic. For

Topic: Oracle DatabaseTags: oracle hierarchy query select data parent child

Views: 11514Comments: 8

Oracle Backup and Recovery: Best Practice #1: RMAN Autobackup

mrjoltcola05/24/2009, 12:00 AM

If you are an Oracle DBA, and you don't know RMAN, don't bet on being taken seriously in a competitive job market. More importantly, you are making your job more difficult by sheer laziness of learning. Many years have passed since Oracle 8 introduc

Topic: Oracle DatabaseTags: rman oracle backup recovery best practices autobackup controlfile parameter mrjoltcola

Views: 10056Comments: 5

How to FTP with Oracle PL/SQL

sdstuber05/09/2010, 12:00 AM

Sometimes you need to get data from a server into your database, or from your database into a remote server.  There are many ways this can be done such as  SOAP or REST web service calls, database links,  pipes,  or external tools.  Another option,

Topic: Oracle DatabaseTags: Oracle, FTP, PL/SQL

Views: 9409Comments: 33

Decoding the Oracle ROWID (and some Base64 for fun)

mrjoltcola06/13/2009, 12:00 AM

Most Oracle programmers have heard of ROWIDs. Many have even used ROWIDs at some point. A few even have an idea of what the ROWID is, logically, but only a very select few actually know the details. It is sufficient to know that the ROWID exists and

Topic: Oracle DatabaseTags: oracle dba rowid base64 dbms_rowid utl_encode base64_decode block mrjoltcola

Views: 7831Comments: 22

Subquery Factoring WITH Oracle

ivostoykov02/02/2010, 12:00 AM

WITH Clause OR Subquery Factoring WITH Oracle by Ivo Stoykov Digging information from a database sometimes requires creating complicated queries. Often a simple select * from . . . is nested into another one and both into another one and so

Topic: Oracle DatabaseTags: WITH Clause Factoring Oracle

Views: 6874Comments: 2

How to use Access Control Lists in Oracle

sdstuber10/28/2011, 12:00 AM

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth

Topic: Oracle DatabaseTags: Oracle, ORA-24247, ACL DBMS_NETWORK_ACL_ADMIN

Views: 6565Comments: 9

How to set multiple events in Oracle

franckpachot10/20/2009, 12:00 AM

A quick example on how to set multiple events. (For example, you are asked by Oracle support to set an event and you already have one that you want to keep) In the spfile: the name is 'event' and values are quoted then comma separated as in:

Topic: Oracle DatabaseTags: set events, set event

Views: 5511Comments: 12
Loading Advertisement...

Top Oracle Database Experts

  1. slightwv

    811,605

    Sage

    12,800 points yesterday

    Profile
    Rank: Genius

  2. sdstuber

    578,296

    Sage

    3,540 points yesterday

    Profile
    Rank: Genius

  3. wasimibm

    159,939

    Guru

    2,100 points yesterday

    Profile
    Rank: Guru

  4. tosse

    83,962

    Master

    1,510 points yesterday

    Profile
    Rank: Master

  5. dvz

    77,992

    Master

    900 points yesterday

    Profile
    Rank: Sage

  6. flow01

    70,666

    Master

    0 points yesterday

    Profile
    Rank: Sage

  7. OP_Zaharin

    66,395

    Master

    0 points yesterday

    Profile
    Rank: Sage

  8. Geert_Gruwez

    66,198

    Master

    800 points yesterday

    Profile
    Rank: Genius

  9. awking00

    63,850

    Master

    0 points yesterday

    Profile
    Rank: Genius

  10. MikeOM_DBA

    55,954

    Master

    10 points yesterday

    Profile
    Rank: Genius

  11. johnsone

    46,104

    0 points yesterday

    Profile
    Rank: Genius

  12. schwertner

    43,375

    0 points yesterday

    Profile
    Rank: Genius

  13. slobaray

    42,921

    20 points yesterday

    Profile
    Rank: Master

  14. Bajwa

    35,334

    1,000 points yesterday

    Profile

  15. gatorvip

    33,868

    0 points yesterday

    Profile
    Rank: Sage

  16. praveencpk

    33,355

    0 points yesterday

    Profile
    Rank: Master

  17. sujith80

    30,896

    0 points yesterday

    Profile
    Rank: Genius

  18. sventhan

    30,548

    0 points yesterday

    Profile
    Rank: Sage

  19. markgeer

    29,292

    0 points yesterday

    Profile
    Rank: Genius

  20. paquicuba

    26,860

    0 points yesterday

    Profile
    Rank: Genius

  21. HainKurt

    24,922

    0 points yesterday

    Profile
    Rank: Genius

  22. Milleniumaire

    20,300

    0 points yesterday

    Profile
    Rank: Sage

  23. ytarkan

    17,352

    0 points yesterday

    Profile

  24. mwvisa1

    15,600

    0 points yesterday

    Profile
    Rank: Genius

  25. angelIII

    14,509

    0 points yesterday

    Profile
    Rank: Elite

Hall Of Fame