Review SQL Execution Plans Before Deployment Using SQL Developer
Use SQL Developer’s SQL Worksheet Explain Plan and Autotrace to catch expensive queries before they reach production.
Loading…
ReadMeFeed / Community knowledge
#oracle-sql-developer
Real questions. Useful conversations. Find the people who know your stack.
sqldeveloperMigrating Schema Data with SQL Developer's Export Wizard: Insert Scripts That Actually Work
Use SQL Developer's Export wizard to generate portable INSERT scripts for schema‑to‑schema data moves. Filter rows, pick the right insert flavour, disable foreign keys, and avoid LOB pitfalls for a reliable, version‑controlled migration.
Choosing the Right Export Format in Oracle SQL Developer: When INSERT Statements Kill Performance
SQL Developer's Export Wizard defaults to INSERT statements, but that format fails catastrophically at scale. This post walks through format selection—INSERT vs Loader vs CSV—with a 10,000-row worked example, delimiter pitfalls, and a verification checklist you can run today.
Moving Oracle Table Data to CSV Without Hand-Written Spool Scripts
Oracle SQL Developer's Export Wizard replaces hand-written spool scripts for moving table data to CSV. Here is how to use it, verify the output, and automate it with sdcli.
Migrating Large Oracle Schemas with SQL Developer’s Data Pump: A Practical Guide
Exporting and importing large Oracle schemas is easier than ever with SQL Developer’s Data Pump wizards. Learn how to configure filters, parallelism, and remapping to move terabytes of data efficiently while avoiding common pitfalls.