Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

backup all db objects

Sa SiJun 19 2013 — edited Jun 21 2013

i need a script to generate the source of every db object to an sql file with object name as file name, if it is a table then that_table.sql if view then that_view.sql like that, but my schema has around 2k objects. i am using toad but as the number of objects are more i am not able to generate source script files for all objects. pls, let me know how to do it. i need this script for version control.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 19 2013
Added on Jun 19 2013
3 comments
275 views