1 in the PowerDesigner table, and the various associations between the tables, when finished, select the menu item in the "Database" under the "Generate Database", find a path, save as a SQL statement.
2 in Pl/sql, tool "Import table, select the file of the SQL statement just now, import."
Seemingly simple, can be imported after clearly 32 sheets, but there are 29, open the SQL file, view the statement of the exported build a lot, this proves that the export is no problem, the key is to import the time, so I did not import the SQL statement of the table, copied to the database execution, the problem came out, Hint Error: Invalid identifier (invalid identifier). Originally, is the field name and Oracle's keywords, there is conflict, so did not guide, I opened the other two are not imported are the same problem, the problem found, this also by the way Oracle in the summary of the keywords, so as to save the future field conflicts. Size,comment,type,name,type,value,validate,file,associate
There is also a problem, the exported SQL file, you must first replace the double quotes, save and then import Oracle, otherwise, imported tables are with double quotes, very uncomfortable, it is said, in the export, there are options can be removed, but did not find, had to manually replace, good test no problem, it can be.
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.