Skip to content

dbForge Studio for Oracle

dbForge Studio for Oracle is a powerful Oracle database development environment that provides you versatile data editing tools for managing in-database and external data. It allows you to synchronize data between different Oracle servers and automate schema change management process during development.

http://www.devart.com/dbforge/oracle/studio/

dbForge Studio for Oracle

Categories

JUMP TO ANOTHER FORUM

11 results found

  1. The tool is adding quotes where they are not needed (for instance if x is a %rowtype and you type x.a it will become x."a" which is not needed).

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Bugs  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  2. Other database clients have the capability to deal with an expired password by changing the expired password of the user account, updating the internal stored password, and logging in with the new password through a simple UI.

    Oracle DB Forge Studio does not offer any option to deal with an expired password, an alternative database client seems to be the only answer.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Bugs  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  3. Fusion doesn't play well with SSDT in the same solution. Fusion grabs all .sql file associations. Double click on a .sql file in Sql Server Database Project and Fusion prompts you for a connection to Oracle. The only way to get the file loaded into SSDT Designer is to right click the file. This could all be solved if DevArt tokenized the file extension and allowed the user to choose: .plsql.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Bugs  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    When installing dbForge Fusion, it becomes the default editor for opening *.sql files and you are asked to select a connection in the dbForge Fusion’s dialog. Though, you can change the default editor in the ‘Open With’ dialog of Visual Studio. For this, please perform the following:

    1. Select ‘File → Open File…’ from the main menu of Visual Studio. The ‘Open File’ dialog opens.
    2. Select a *.sql file and click the down-arrow against the ‘Open’ button.
    3. Select ‘Open With…’.
    4. Select an editor and click ‘Set as Default’.
    5. Click ‘OK’.

  4. Extracting DDL for a table with Automatic partitioning fails to add "AUTOMATIC" keyword. E.Q.

    PARTITION BY LIST ("CAR_ID") AUTOMATIC

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    under review  ·  0 comments  ·  Bugs  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  5. SELECT CURSOR( SELECT * FROM dual ) FROM dual;
    Returns ORA-01001: invalid cursor
    On second try to open cell, the app crashes.
    Other tools let you explorer contents of cursor.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Bugs  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  6. Forget about caching metadata. This is the biggest foolishness I ever saw.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Bugs  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  7. If you start the search in one window and then attempt to search the same word in another document, the search will be running in the initial window instead of the active one. With this, the focus will switch to the initial window.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Bugs  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  8. Data in global temporary tables not showing in data explorer of table, but in query like "select * from some_gtt" all data is visible. Version of DB Forge Studio is 4.0.237

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Bugs  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  9. Tooltip hinders when clicking on the tabs panel.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Bugs  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  10. 1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Bugs  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  11. I have column definied by:

    AA CHAR(1 CHAR) DEFAULT 'Y' NOT NULL

    I want to check this column with "DEFAULT ON NULL".

    After checking this option in dbForge Studio 2021 4.3.34 column definition changes to:

    AA CHAR(1 CHAR) DEFAULT BY DEFAULT ON NULL 'Y'

    what is incorrect.

    My database: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.3.0.0.0

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Bugs  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  • Don't see your idea?