![]() Visual SQL/Query Builder will help you create, edit and run SQL statements/queries without having to worry about syntax and proper usage of commands. Code fast with Code Completion and customizable Code Snippet by getting suggestions for keywords and stripping the repetition from coding. Quickly locate and correct PL/SQL and PL/PGSQL coding errors using our debugging component such as setting breakpoints, stepping through the program, viewing and modifying variable values, and examining the call stack.Ĭreate, modify and manage all database objects using our professional object designers. Convert your databases into graphical representations using a sophisticated database design and modeling tool so you can model, create, and understand complex databases with ease. The syntax of the two databases is different, and the table field types are also different.Our powerful local backup/restore solution and intuitive GUI for MongoDump, Oracle Data Pump and SQL Server Backup Utility guides you through the backup process and reduces the potential for errors. 4, Use the data transfer function of Navicat tool to transfer the specified tables in Oracle database to mysql database. Query OK, 0 rows affected, 1 warning (0.00 sec)Īt this point, use Navicat tool to connect to mysql successfully. ![]() Mysql> GRANT ALL PRIVILEGES ON *.* TO IDENTIFIED BY '123456' WITH GRANT OPTION enter the mysql container and authorize the mysql root user to connect remotely ~]# docker exec -it mysql sh Note: remember to close selinux, otherwise an error may be reported. ②, run mysql container ~]# docker run -d -p 3306:3306 -name mysql -v /opt/mysql/data:/var/lib/mysql -v /opt/mysql/logs:/var/log/mysql -v /opt/mysql/conf:/etc/mysql/ -e MYSQL_ROOT_PASSWORD=123456 mysql:5.7.20 pull mysql image mnt]$ docker pull mysql:5.7.20 Import terminated successfully without warnings.Ĭheck through Navicat management tool that there are already WO_ORDER table! 3, Build Mysql database through Docker. importing table "WO_ORDER" 1540160 rows imported Import server uses ZHS16GBK character set (possible charset conversion) Import again after modification: mnt]$ imp file=/mnt/sxgddzhdaochu20220302.dmp ignore=y full=y SQL>ALTER DATABASE CHARACTER SET INTERNAL_USE ZHS16GBK At this time INTRENAL_USE Directive does not check character set supersets. Prompt that the new character set must be a superset. ORA-12712: new character set must be a superset of old character setĭon't panic if you report an error at this time. SQL> ALTER DATABASE CHARACTER SET ZHS16GBK SQL>ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0 SQL>ALTER SYSTEM ENABLE RESTRICTED SESSION Terms of settlement: SQL>connect username/password as SYSDBA Roughly, the character set of the dmp file does not match the character set of the built abc database, so an error is reported! ORA-12899: value too large for column "SYSTEM"."WO_ORDER"."CALLIN_CODE" (actual: 33, maximum: 30) IMP-00003: ORACLE error 12899 encountered IMP-00019: row rejected due to ORACLE error 12899 Import server uses A元2UTF8 character set (possible charset conversion)Įxport client uses ZHS16GBK character set (possible charset conversion) Import done in US7ASCII character set and AL16UTF16 NCHAR character set Warning: the objects were exported by SXGDDZH, not by you ![]() With the Partitioning, OLAP, Advanced Analytics and Real Application Testing optionsĮxport file created by EXPORT:V11.02.00 via conventional path All rights reserved.Ĭonnected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production Report errors: mnt]$ imp file=/mnt/sxgddzhdaochu20220302.dmp ignore=y full=y *****: represents the import data into abc databaseįile: the absolute path of the imported file. ① Import with imp command mnt]$ imp file=/mnt/sxgddzhdaochu20220302.dmp ignore=y full=y Reference connection: 3, Import dmp backup file from Oracle database. It is roughly installed using Centos7 desktop server. Ignore this step and go through a bunch of installation tutorials. ④ Use Navicat tool and the tool data transfer function to transfer Oracle data to mysql! 2, Install the Oracle database. ③ Install a MySQL database or use an existing MySQL database. ② Import the dmp file in Oracle format provided by Party A into our self built oracle. Party A has given the dmp file in oracle format! The customer of the first project is oracle database, which needs to import a table data to the mysql database of the self research system. Oracle database dmp to mysql format 1, Background
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |