#13 Lack of SYS. prefix in Queries

Released in 1.4x
closed-fixed
SQL (23)
7
2006-01-31
2005-02-09
No

Use dba_ views for DDL reverse-engineering because
sometimes objects from other schemas are not visible in
all_ views

Discussion

  • Aleksey Kochetov

    Logged In: YES
    user_id=423922

    some additional suggestion from sqltools forum:
    add "sys." prefix for all views for avoiding interference
    with user objects

     
  • Drzewiecki T.

    Drzewiecki T. - 2005-06-17

    Logged In: YES
    user_id=747155

    Try to (not in SYS schema!):
    CREATE TABLE all_tables AS
    SELECT 'hello' hello FROM dual;

    Refresh Object List: "ORA-00904 : IOT_NAME : invalid
    identifier". Extracting DDL isn't possible!

     
  • Drzewiecki T.

    Drzewiecki T. - 2005-06-17
    • summary: Use dba_ views for DDL reverse-engineering --> SYS. & dba_ views for DDL reverse-engineering
    • priority: 5 --> 7
    • milestone: 461922 --> 461921
    • labels: 693836 --> SQL
     
  • Drzewiecki T.

    Drzewiecki T. - 2005-06-23
    • summary: SYS. & dba_ views for DDL reverse-engineering --> Lack of SYS. prefix in Queries
    • status: open --> closed
     
  • Drzewiecki T.

    Drzewiecki T. - 2005-06-23

    Logged In: YES
    user_id=747155

    I added prefix SYS. in every place where was selected ALL_
    view.

    In some places currently we are using DBA_ views (if user is
    logged as SYSDBA).
    There is no need to specially select some tables/views with
    DBA_ because it depends on security settings.

    But if I will see examples of wrong extracting - I will add it as
    separate bug.

     
  • Drzewiecki T.

    Drzewiecki T. - 2005-06-27
    • assigned_to: nobody --> tmk_pl
     
  • Drzewiecki T.

    Drzewiecki T. - 2006-01-19
    • milestone: 461921 --> 455736
    • status: closed --> closed-fixed
     
  • Drzewiecki T.

    Drzewiecki T. - 2006-01-31
    • milestone: 455736 --> Released in 1.4x
     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.





No, thanks