Copying Tables, Constraints, views, procedures and other schema objects in oracle

Question

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 15-Feb-12 8:26am

prathameshpitale

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

ssd_coolguy · Answer 1 · 2012-05-16T00:02:00

Solution 1

You can create dmp file and import into new account.

Posted 16-May-12 0:02am

ssd_coolguy

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 ;)