C# Corner
Tech
News
Videos
Forums
Jobs
Books
Events
More
Interviews
Live
Learn
Training
Career
Members
Blogs
Challenges
Certification
Contribute
Article
Blog
Video
Ebook
Interview Question
Collapse
Feed
Dashboard
Wallet
Learn
Achievements
Network
Refer
Rewards
SharpGPT
Premium
Contribute
Article
Blog
Video
Ebook
Interview Question
Register
Login
Get Multiple User-Selected Table & Procedure Scripts in Oracle (Schema + Data)
WhatsApp
Sandhiya Priya
May 17
605
0
6
25
Blog
Export Selected Tables (Schema + Data)
Open Oracle SQL Developer
Connect to your target database
Go to Tools -- Database Export
In the Export Wizard,
Connection: Choose your database
Export DDL: Tick is Enabled
Export Data: Tick is Enabled
Object Types: Select Tables
Click the edit icon (pencil) to choose specific tables manually
Check theTick Export DDL and Export Data
Under the standard Object Type Tick, which one is required to choose, like Tick Tables, Procedure, etc.
Based on the Table and Procedure, select and double click it will be listed on the right side content added.
You Can See the Table (tables icon) and Procedure like (Procedure icon)
Choose
Format: SQL
Output File: Save to .sql
Click Next -- Finish
This creates a script with,
CREATE TABLE statements
INSERT INTO statements for each selected table
Export Data
Export Schema
Oracle Server
Procedure Scripts
Table Scripts
People also reading
Membership not found