开发者

How to create dump into separated files

开发者 https://www.devze.com 2023-01-14 23:58 出处:网络
In addition to How to create a dump with Oracle PL/SQL Developer? Is that possible to create a dump into separated files: I prefer the each stored object has its own file. So as result I want N files

In addition to How to create a dump with Oracle PL/SQL Developer?

Is that possible to create a dump into separated files: I prefer the each stored object has its own file. So as result I want N files with views description (1 view per 1 file), M files with SP, O files with tables, etc

Is that possible?

UPD: i've found the answer in the current using oracle management tool we use - TOAD. so i 开发者_StackOverflow社区decide to use it.


Sort of.

I'd use DBMS_METADATA.GET_DDL to extract the "Create object" text, and UTL_FILE to write the text to a file on the database server. You need to decide whether you want indexes/constraints with the tables. With constraints, you'll get dependencies (ie table B has to be created before table A because of a referential integrity constraint).

It gets more complicated with triggers, types, procedures...

And then there's whether yo want the data or not.

Its very difficult to determine the order in which you'd have to run the files.

0

精彩评论

暂无评论...
验证码 换一张
取 消