Adding packages to Cart in SQLDeveloper

1. Re: Adding packages to Cart in SQLDeveloper

RodWest Jan 17, 2013 8:21 AM (in response to Omar M Sawalhah)

Currently Being Moderated

Hi,

Your best option may to be generate a DDL script for all the packages using the DBMS_METADATA package or other tool and then add the script to the cart.

Rod West

3. Re: Adding packages to Cart in SQLDeveloper

RodWest Jan 29, 2013 1:59 PM (in response to Omar M Sawalhah)

Currently Being Moderated

Hi,

The DBMS_METADATA package is for DDL so not suitable for creating scripts to move data. If you want to generate a script containing insert statements for your table data then you need to use the SQL Developer export as insert statements or alternatively write you own SQL which will dynamically generate the required SQL inserts.

Rod West

5. Re: Adding packages to Cart in SQLDeveloper

RickG Jan 31, 2013 10:44 AM (in response to Omar M Sawalhah)

Currently Being Moderated

Omar -

You can use SQL Developer to create scripts to export sample data by adding a WHERE clause to your export - it's called the Global Where in the SQL Dev export wizard. You can also specify DDL as part of the script. Do this for each of the tables you want to move and then load the resulting scripts in the SQL Workshop area of Application Express in the Cloud.

When you export the DDL, the script will include the constraints, such as the foreign keys. You will simply have to run the scripts in the appropriate order to avoid constraint violations.

Hope this helps.

- Rick Greenwald

7. Re: Adding packages to Cart in SQLDeveloper

vuvarov Feb 5, 2013 1:27 PM (in response to Omar M Sawalhah)

Currently Being Moderated

Hi Omar,

There are 2 ways to see data loading errors: 1) using SQL Developer, or 2) using SFTP.

1) In SQL Developer, find your deployment under Cloud Connections / Deployments. Open the LOGS tab and find the [table name]_DATA_TABLE.ctl record for the table in question. Double-click the DETAILS cell. You should see a popup with SQL*Loader output for this table, which will show ORA errors for rejected records.

2) Connect using SFTP account associated with your database service. The "download" directory should contain a zip file for your deployment (for example: LOG_deploy.zip). This zip file will contain SQL*Loader log file(s) that will also list any data loading errors.

-- Vlad