The following are some problems that may occur during the operation, some of which have been mentioned in the above operation.
-
Communication link failure or general network error
The reason for the problem: If you check “Close existing connection” when deleting the database, the database connection configured by PD will be disconnected, and when the script is executed in PD again There will be a “communication link failure” problem; or the connection has not been configured; or the connection is configured, but not connected;
The solution is: After selecting “Ignore All”, confirm that the connection configuration is correct, and then connect (refer to the above steps To proceed).
-
When executing the script, it prompts “Object not found** because it does not exist or you do not have the required permissions ”
Cause of the problem: Because the table does not exist in your current target database, when the script executes the delete operation The problem will be prompted; in addition, confirm that the script does have dba permissions;
Solution: Directly “Ignore All” to check whether the table to be created already exists in the database, if not, please see the next question first and refer to its solution After the method is executed, execute the script again, select “Ignore All”,
look at the database again to see if a new table has been generated. If the tables have been generated, the above questions will no longer be prompted when the script is executed again, because these tables can be found when the script executes the delete operation. If the problem is still prompted when the table already exists,
you need to pay attention to the permission problem.
-
The script execution ends, and no table is created in the database
The reason for the problem: the script execution is to select the database object;
Solution: Change the default connection database in the configuration connection or add a sentence “USE DB_Name” before this script, where DB_Name is the database you want to create the table;
Note: The script will first delete the table with the same name to be created. Then create, if there is no table with the same name, the above problem will occur.
willem organize/update 09:13:27, November 29, 2016