I have created a financial software, i need to change the financial year.
we planned that we will make new user account into oracle and copy tables , Constraints, views, procedures and other schema objects and SOME Data from prvious year to the new User account.
Can you please tell me how can we accomplish this ?
how can i Extract DDL statements of various schema objects from Oracle's Data Dictionary!
We dont want to manually add the script into desktop application and run it to create Objects in new user accounts as Changes to database will be very often.
Also exp command is not suitable for us.