v2.0
- Overview
- Environment
- Quick Start
- Configuration
- Commands
- mtk
- init-project
- config
- license
- mig
- show
- sync
- sync-schema
- sync-sequence
- sync-object-type
- sync-domain
- sync-wrapper
- sync-server
- sync-user-mapping
- sync-queue
- sync-table
- sync-nickname
- sync-rule
- sync-table-data
- sync-table-data-estimate
- sync-index
- sync-constraint
- sync-db-link
- sync-view
- sync-mview
- sync-function
- sync-procedure
- sync-package
- sync-trigger
- sync-synonym
- sync-table-data-com
- sync-alter-sequence
- sync-coll-statistics
- check-table-data
- gen
- gen completion
- encrypt
- convert-plsql
- report
- self
- mvd
- usql
- Graphical
- Faqs
- Release
mtk show-table
display size of the top n table to be migrated
Synopsis
display size of the top n table to be migrated
mtk show-table [flags]
Examples
mtk -c mtk.json show-table
mtk -c mtk.json show-table --schemas MTKSCH,MTKSCH1 -n 40
mtk -c mtk.json show-table --tables MTKSCH.MTK_KAFKA_PERFORMANCE_1,MTKSCH.MTK_KAFKA_PERFORMANCE_2% -n 40
mtk -c mtk.json show-table -n 10
TabName Partitioned TotalSize DataSize LobSize Rows AvgRowsLen ColCount
MTKSCH.MTK_KAFKA_PERFORMANCE_1 false 10.43GiB 10.43GiB 0B 41000960 260B 8
MTKSCH.MTK_KAFKA_PERFORMANCE_2 false 10.43GiB 10.43GiB 0B 41000960 260B 8
Options
--detail Display partition table partition size information
-h, --help help for show-table
-n, --top int top num (default 20)
Options inherited from parent commands
--caseSensitive int Object case parameters in SQL statements.
1 - lower case
2 - upper case
3 - Keep it the same as the source database.
-c, --config string Set mtk config file. Support json,yaml. [env MTK_CONFIG] (default "mtk.json")
-d, --debug Set the debug mode.
Not necessary for the normal usage. [env MTK_DEBUG]
--disableIgnoreCase Disable ignoring case queries
--enableSyncCompTabPro Enable Synchronize table compressed properties
--file export to file
--fileType string Indicates the type of a file when data is to be exported to a file.
support csv,sql
--license string Specify the license file
--noTerminalReport The terminal does not print an overview of the migration report
-p, --parallel int Specify the parallelism.
the degree of parallelism is now only useful when migrating table data and parallelism when creating an index. (default 1)
--path string Indicates the directory of a file to which data is to be exported.
Default value is config.target.parameter.path. If not configured, the system default value ./data
Command Value > Config Value > MTK Default Value
--preRun preRun check.
-r, --reportFile string Set mtk report file or dir. If it is a file, use the file directory.
Default value is ./report
report directory format [./report/reportYYYYMMDDHHMISS] ./report/report20210101121314
--schemas string the Migrate schema,Separated by commas.(schema1,schema2,db1)
--tableSkip stringArray Define table split. Can be specified multiple times.
format schema.tableName --tableSkip MTK.TABLE01 --tableSkip MTK.TABLE02
--tables string the Migrate tables,Separated by commas.(tab1,schema1.tab1)
SEE ALSO
- mtk - Database Migration Toolkit