Click here to Skip to main content
14,969,910 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hello,
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.

Prathamesh
Posted

1 solution

You can create dmp file and import into new account.
   
Comments
prathameshpitale 16-May-12 7:28am
   
I have read some where Dump file contains data also.
ssd_coolguy 17-May-12 0:32am
   
you mentioned that you need data also.. :)
but if you don't want data then while ceating dmp file give rows='N' parameter.
prathameshpitale 17-May-12 0:35am
   
thanks. But I need data only from specific tables such as company information and Master Tables,
any ways thanks.
ssd_coolguy 17-May-12 1:12am
   
1.Create dmp file without data and insert it into new account.

2.Create another dmp file for only those table for which you needs data too.(give table name while creating dmp file)

3.drop those tables from new account and insert another (step 2) dmp in new account.

hope above steps will helps..
prathameshpitale 17-May-12 5:05am
   
Oh wow.. Great. Thank you!
ssd_coolguy 17-May-12 6:34am
   
welcome...
accept the solution ;)

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900