migrate data from oracle to mongodb

recently encountered a requirement to migrate data from a subset of the tables in Oracle to a SQL Server database. But the structure of these tables is somewhat different. method one, using the SQL Develper Data Export tool, export the SQL INSERT statement, and then manually modify some of the details, and finally p

This article describes the method of Oracle data import and export under Linux. Share to everyone for your reference, specific as follows: A. Export tool exp 1. It is the next executable file storage directory for the operating system/oracle_home/bin The EXP export tool compresses data backups in a database into a binary system file. Can

Property_name, Property_value 2 from Database_properties 3 WHERE property_name like '%characterset '; Property_name Property_value See more highlights of this column: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/ ------------------------------ -------------------------------------------------- Nls_characterset ZHS16GBK Nls_nchar_characterset AL16UTF16 Sql> Show PARAMETER Db_block_size NAME TYPE VALUE ------------------------