An accounting server, installed oracle11g and uf software, a few days ago suddenly suddenly down, may be the mainboard is broken, can't start,

It has 4 years of accounting data, although the data backup is out, but after recovery software found abnormal, missing the menu, then please people, ufida company is 11 g bug, no data table will not export, so when the import also has a problem,

So now want to consult everybody a great god, and I can on the basis of the existing data, restore the software menu, with background data of accounting software tools to build a new user in the oracle, there is a menu, can put the missing part of the data, now with the new users to replace?

CodePudding user response:

Then separate build no data table structure

CodePudding user response:

The mainboard is broken, no bad hard disk, cold standby is ok,

CodePudding user response:

First said, not 11 g bug, is to join a new mechanism, which can be through the allocate among modify
Second, since no data, with the initial tools or looking for a manufacturer, to build table

CodePudding user response:

A data table back? No data in the table to build the table not just

CodePudding user response:

Thanks for your reply!

In oracle, is not very good basic will only imp and exp, perform software company send some SQL statements, because usually use less, also too lazy to learn

This two days to catch up with the next, indeed you are right, there is no table a new line, then caused the lack of table view recompilation, build table script off-the-shelf software installation CD, just want to according to the error messages to find the

This two weeks the most heavy blow suffered career, because it is a superposition of two factors together, the server is raid5 array, the motherboard is damaged, began to not recognize array CARDS, then simply can't boot, data cannot out naturally, backup the characteristics of good data for oracle recovery after abnormal, cause they are passive

Pay the friend is solved finally, 40000 8, although is unit pay, but his heart is very depressed,,,

CodePudding user response:

reference 5 floor lkingsd reply:

thanks for your reply!

In oracle, is not very good basic will only imp and exp, perform software company send some SQL statements, because usually use less, also too lazy to learn

This two days to catch up with the next, indeed you are right, there is no table a new line, then caused the lack of table view recompilation, build table script off-the-shelf software installation CD, just want to according to the error messages to find the

This two weeks the most heavy blow suffered career, because it is a superposition of two factors together, the server is raid5 array, the motherboard is damaged, began to not recognize array CARDS, then simply can't boot, data cannot out naturally, backup the characteristics of good data for oracle recovery after abnormal, cause they are passive

Pay the friend is solved finally, 40000 8, although is unit pay, but his heart is very depressed,,,

In general as long as it is backed up, IMP import system is basically won't have a problem, for example, the menu is certainly no problem, just say some incremental data can be lost, but not all the menu data all have no, doubt is you didn't import into the whole user to recompile, lead to some object or an error (process, function, view, etc.), compile the estimated for a few minutes, this money is really depressed