Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Generate DDL option

Received Response
1
Views
3
Comments
Sangeeta Pandey
Sangeeta Pandey Rank 6 - Analytics Lead
edited Aug 13, 2024 5:17PM in Oracle Analytics Cloud and Server

Hello Expert,

I created one table at physical layer of RPD and need to create the same at DB.

Not sure if OBIEE tool provides option to generate DDL for the table which can be executed as script at db.

If not then I need to manually create DDL .

Thanks,

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Normally you start in the DB and then import in the RPD. OBI isn't a tool to create DB objects. It's an analytical platform. You can use SQL Developer to create the DDL for you.

  • Sangeeta Pandey
    Sangeeta Pandey Rank 6 - Analytics Lead

    Hi Chris,

    Make sense, how ever wondering if it could have option to generate equivalent DDL for each db object created directly than importing from DB and such way we could have executed generated DDL  through sql developer to get DB objects created.

    Thanks your response !!!

    Thx

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    No. That's not the aim or the point of the tool.