在oracle中复制表，约束，视图，过程和其他模式对象 [英] Copying Tables, Constraints, views, procedures and other schema objects in oracle

问题描述

你好，
我已经创建了财务软件，我需要更改财务年度.
我们计划将新的用户帐户添加到oracle中，并从上一年开始将表，约束，视图，过程和其他架构对象以及某些数据复制到新的用户帐户中.

你能告诉我如何做到吗?

如何从Oracle数据字典中提取各种模式对象的DDL语句！

我们不想手动将脚本添加到桌面应用程序中并运行它以在新的用户帐户中创建对象，因为对数据库的更改将非常频繁.

同样，exp命令不适合我们.

Prathamesh

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

推荐答案

您可以创建dmp文件并导入到新帐户中.

You can create dmp file and import into new account.

这篇关于在oracle中复制表，约束，视图，过程和其他模式对象的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！