8 likes
·
1.3K reads
3 comments
Great blog post, Sandra! I have a little hack for you. If you want to re-sequence a column, just right click on the "read only" sequence number and remove readonly="true". Supported? Definitely not, but it works just fine :)
Also, you should be able to generate directly into tables even if you create a blueprint from scratch. You just need to make sure the table names, columns, constraints, etc. all work.
Thanks Anton for visiting and reading my blog and for your comments too. I appreciate the hack and I retested the feature to generate directly into tables and yes, as long as the table name on your blueprint is an exact match to the table name in your schema, it works. I've updated the blog with this tip. Thanks again!
sssuarez Just one more tip...OADG is accessible via APIs (note: I wasn't able to post links, so I put a space between https:// and the rest of the URL): https:// docs.oracle.com/en/database/oracle/apex/22… In particular, if you want to generate data into just one table, you can use APEX_DG_DATA_GEN.GENERATE_DATA https:// docs.oracle.com/en/database/oracle/apex/22…
Use p_blueprint_table to specify the table name.