#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2013
    Posts
    1
    Rep Power
    0

    Turning a table model into a DDL to import into APEX


    Im a total noob when it comes to oracle but im taking a class where we use apex and my professor wants us to import a table model into apex. everytime i try and import my table it says "your export file is not supported". i asked my professor what to do and he said "You should gen a ddl file from designer. Then use that to upload into apex and then run." im not sure what that means exactly. any ideas?
  2. #2
  3. Contributing User
    Devshed Novice (500 - 999 posts)

    Join Date
    Sep 2006
    Posts
    859
    Rep Power
    388

    Cool


    Originally Posted by verifyjjones
    ... Etc ... "You should gen a ddl file from designer. Then use that to upload into apex and then run." im not sure what that means exactly. any ideas?
    Use DBMS_METADATA.GET_DDL() package to get the ddl.


    PS: What designer are you using? Anyway, whatever designer software can generate ddl for any of the objects you created.
    Last edited by LKBrwn_DBA; May 2nd, 2013 at 01:27 PM.

IMN logo majestic logo threadwatch logo seochat tools logo