To back up the data, you need to export the complete data of 11 GB users on the server. The client on the machine is oracle10g. Run the command: exp ******* @ ***** file *****. dmp
To back up the data, you need to export the complete data of 11 GB users on the server. The client on the machine is oracle10g. Run the command: exp ***/*** @ *** file = ***. dmp
To back up the data, you need to export the complete data of 11 GB users on the server. The client on the machine is Oracle10g. Run the command: exp ***/*** @ *** file = ***. dmp full = y
After the command is executed, the system prompts:
EXP-00008: ORACLE error 1406
ORA-01406: extracted column values are truncated
EXP-00000: Export termination failed
I checked a number of materials, some said that the client and the server did not match, but the leaders said that the machine was used for backup in January. Then there were a lot of searches on the fly with no head, but there was no way. Finally, the leader told him to export the written exp and asked me what full = y meant. At that time, it was not clear that this was to export all data objects under the instance where the current user is located. Sorry, you are ignorant! I only need to back up the data of the current user. Then we removed the full = y at the end, and added the owner = *** (the same as the previous one). Finally, we were able to see the backed up data tomorrow. Self-satisfied.