Hello guys
I need to export my schema into sql files, I know that using SQL Developer I’m able to do so but I need to export the database by a certain template
first I need to export each object in a file by file type
also I need to export all The constraints oc a table in the Same file as the table
I need to be able to specify the formatting of the scripts (upper, lower case, indentation...)
i need to be able to specify what types to export and each type inside a sperate folder
I also need to be able to extract Data from certain tables and specify the sequence of each table
I tried plsql develroper, sql developer, toad for oracle but I couldn’t find everything I need in a single software
is there any software that’s able to do all this in one shot ? Or for example a script that can help me do so ?
thanks in advance