sch Document
01688
검색 초기화
    GitHub
    GitHub
    • sch Document
      • Index
        • 각종 프롬프트 모음
      • AWS
        • Amplify
        • Athena
        • CDK
          • Example (JavaScript, TypeScript)
        • CLI
        • CloudFormation
        • DMS
          • Oracle DMS
          • PostgreSQL DMS
        • ELB
        • Glue
        • IAM
        • RDS
          • Aurora
            • Aurora 구성 및 특징
          • RDS MySQL
            • 인스턴스 생성 방법
            • Log
            • Optimized Writes
          • RDS Oracle
            • RDS에서의 권한 관리
            • 인스턴스 생성 방법
            • Datapump
            • Memory, Swap 문제
            • RDS Oracle의 자원 할당량
            • S3 관련 명령어
            • S3 INTEGRATION
            • Spatial
            • Temporary Tablespace
            • Timezone
          • RDS PostgreSQL
        • S3
        • Snapshot
        • Session Manager
      • C#
        • Array
        • DataTable
        • DateTime
        • Directory
        • FileInfo
        • Standard Numeric Format String
        • StringReader
      • etc
        • B Tree
        • CHAR와 VARCHAR의 차이
        • CIDR (Classless Inter-Domain Routing)
        • CPU Scheduling
        • End of Line
        • Hash
        • IP Class
        • Isolation Level (격리 수준)
        • Keepalive
        • nkf Network Kanji Filter (Shift JIS의 특수문자 처리)
        • ora2pg
        • Regular Expression
        • REST API
        • Snapshot
        • TCP Flag
      • ETCD
      • Excel
      • Flutter
      • git
      • gitmessage.txt
      • HAProxy
      • JavaScript
      • Linux
        • CentOS-Base.repo
        • HugePage
        • inode
        • Transparent HugePages
      • MySQL
      • Error
      • Parameter
        • Analyze
        • Cast
        • Cluster
          • InnoDB Cluster
          • NDB Cluster
        • Constraint
        • Data Format
        • Date Format
        • Double Write Buffer
        • ERROR 1045 (28000): Access denied for user 'user_name'@'host_name' (using password: NO)
        • Unknown table 'column_statistics' in information_schema (1109)
        • ERROR 1153 (08S01) at line 45: Got a packet bigger than 'max_allowed_packet' bytes
        • ERROR 1194 (HY000): Table 'table_name' is marked as crashed and should be repaired
        • ERROR 1227 (42000) at line 18: Access denied; you need (at least one of) the SUPER privilege(s) for this operation
        • Got fatal error 1236 from master when reading data from binary log: 'Client requested master to start replication from position > file size; the first event 'binary_log.000000' at 000000000, the last event read from '/directory_name/log/binary_log.000000' at 4, the last byte read from '/directory_name/log/binary_log.000000' at 4.'
        • Error Code: 1248. Every derived table must have its own alias
        • ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
        • ERROR 1300 (HY000): Invalid utf8mb4 character string:
        • Error Code: 1337. Variable or condition declaration after cursor or handler declaration
        • ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you might want to use the less safe log_bin_trust_function_creators variable)
        • ERROR 1486 (HY000): Constant, random or timezone-dependent expressions in (sub)partitioning function are not allowed
        • Error Code: 1493. VALUES LESS THAN value must be strictly increasing for each partition
        • Error Code: 1503. A PRIMARY KEY must include all columns in the table's partitioning function
        • Error Code: 1505. Partition management on a not partitioned table is not possible
        • Error Code: 1520. Reorganize of range partitions cannot change total ranges except for last partition where it can extend the range
        • ERROR 1563 (HY000): Partition constant is out of partition function domain
        • Error Code: 1786. Statement violates GTID consistency: CREATE TABLE ... SELECT.
        • 1831 Duplicate index 'index_name' defined on the table 'schema_name.table_name'. This is deprecated and will be disallowed in a future release.
        • ERROR 2002 (HY000): Can’t connect to local MySQL server through socket 'directory/mysql.sock' (2)
        • Error Code: 3100. Error on observer while running replication hook 'before_commit'.
        • ERROR 3948 (42000): Loading local data is disabled; this must be enabled on both the client and server sides
        • Column statistics
        • ERROR at line : Unknown command '\''
        • Event Scheduler
        • Explain
        • Function
        • GTID (Global Transaction Identifier)
        • Huge Page
        • Index
        • INSERT INTO ~ ON DUPLICATE KEY UPDATE
        • Install
        • Isolation Level
        • Load Data
        • Log
          • binary log
          • general log
          • relay log
          • slow query
        • mysql
        • mysql shell
        • mysql shell dump
        • mysqlbinlog
        • mysqld
        • mysqldump
        • mysqldump, mysqlpump, mydumper, mysqlshell dump의 차이
        • Parameter
        • binlog_row_image
        • group_concat_max_len
        • innodb_additional_mem_pool_size
        • innodb_autoextend_increment
        • innodb_buffer_pool_chunk_size
        • innodb_buffer_pool_instances
        • innodb_buffer_pool_size
        • Innodb data file path
        • innodb_doublewrite
        • innodb_doublewrite_batch_size
        • innodb_doublewrite_dir
        • innodb_doublewrite_files
        • innodb_doublewrite_pages
        • innodb_file_per_table
        • innodb_flush_log_at_timeout
        • innodb_flush_log_at_trx_commit
        • innodb_flush_method
        • innodb_flush_neighbors
        • innodb_flush_sync
        • innodb_io_capacity
        • innodb_io_capacity_max
        • innodb_page_size
        • innodb_read_io_threads
        • innodb_support_xa
        • innodb_use_sys_malloc
        • innodb_write_io_threads
        • local_infile
        • log_bin_trust_function_creators
        • lower_case_table_names
        • sync_binlog
        • Partition
        • Persist
        • Procedure
        • Process
        • Profiling
        • Duplication
          • Replication
          • Mysql High Availability
          • Semi-sync Replication
        • Router
        • Schema
        • Spatial
        • SQL Mode
        • Table
        • Tablespace
          • 시스템 테이블스페이스
        • Time Zone
        • User
        • View
      • Oracle
      • Error
      • Parameter
        • 상황별 자주 쓰는 SQL
        • Active Duplication
        • Analyze
        • Analyze와 DBMS_STATS의 차이
        • Automated Maintence Task
        • AMM (Automatic Memory Management)
        • ASMM (Automatic Shared Memory Management)
        • Block
        • CBO, RBO
        • Compare Features
        • Compression
        • Constraint
        • Datapump
        • DB Link
        • Dimension
        • Direct Path Load
        • Enqueue
        • 00054
        • 00059
        • 00439
        • 00900
        • 00911
        • 00932
        • 00955
        • 00959
        • 00972
        • 00988
        • 00997
        • 01008
        • 01013
        • 01017
        • 01153
        • 01418
        • 01438
        • 01476
        • 01502
        • 01549
        • 01555
        • 01652
        • 01654
        • 01658
        • 01688
        • 01779
        • 01790
        • 01795
        • 01861
        • 01922
        • 01940
        • 01950
        • 02019
        • 02082
        • 02287
        • 02429
        • 02437
        • 03214
        • 04031
        • 08180
        • 10631
        • 10636
        • 12014
        • 12162
        • 12537
        • 12545
        • 12703
        • 12719
        • 12838
        • 12899
        • 14047
        • 14086
        • 14400
        • 14451
        • 14511
        • 14701
        • 19573
        • 22835
        • 22858
        • 22868
        • 22998
        • 24344
        • 28000
        • 28040
        • 29851
        • 30036
        • 30052
        • 30926
        • 32463
        • 38029
        • 38104
        • 39809
        • 60100
        • 65096
        • LPX 00216
        • SP2 0591
        • SP2 0618
        • Expdpimpdp
        • Explain
        • Export csv
        • Flashback
        • Gathering (통계 수집)
        • Hint
        • HugePage
        • Identity
        • Index
          • Bitmap
          • Oracle Text
          • Oracle Text에 대한 자세한 설명
          • Oracle Text 인덱스와 % 의 성능 비교
        • Install Oracle Client
        • Latch
        • Cache Buffers Chains
        • Library Cache
        • Literal SQL
        • LOB (Large Objects)
        • Log
          • Archive
          • Supplemeltal Log
          • Trace
        • Merge Into
        • NLS Parameter
        • db_block_%
        • db_file_multiblock_read_count
        • db_writer_processes
        • dbwr_io_slaves
        • pool_size
        • sec_case_sensitive_logon
        • sec_case_sensitive_logon
        • session_cached_cursors
        • sort_area_size
          • PFILE, SPFILE
        • Parsing
        • Partition
        • Patch
        • PCT
        • Process
        • Query Rewrite
        • Regular Expression
        • Report
          • ash Report
          • awr Report
          • Statspack
        • Row Level Lock
        • Sequence
        • Session
        • Shrink
        • SQL Loader
        • SQL Plus
        • Synonym
        • Table
          • Temporary Table
        • Tablespace
        • BIGFILE과 SMALLFILE의 차이
        • 테이블 스페이스 내부 데이터 크기를 확인하여 변경
        • Temporary Tablespace
        • UNDO Tablespace
        • Trigger
        • User
        • View
          • Materialized View
        • With
      • PostgreSQL
      • Parameter
        • PostgresSQL HA 구성 (Cluster)
          • Patroni
          • pgbackrest
        • Database
        • Extension
          • dblink
          • oracle_fdw
        • Install
        • pg_ctl
        • PGBADGER
        • pgbench
        • psql
        • Schema
        • Sequence
        • Serial
        • Server
        • Session
        • Timezone
        • User
        • User Mapping
      • python
      • Error
        • Breakpoint
        • Datetime
        • Consider using the --user option or check the permissions.
        • AttributeError
        • Indent
        • TypeError
        • Json
        • Time
      • Shell
        • crontab
        • export
        • find
        • grep
        • head
        • iconv
        • iostat
        • sar
        • sleep
        • sudo
        • tail
        • timedatectl
        • top
        • user
        • vi
        • VNC
      • Terraform
        • Terraform Module
      • UiPath (C#)
      • Vue
        • Error
        • Quasar
      • Windows
        • Power Shell
        • RDP (Remote Desktop Protocol)
        • WSL (Windows Subsystem for Linux)

    01688

    ===

    해당 테이블스페이스의 용량이 작업할 용량보다 작음 (파티션)

    1. 테이블 스페이스 용량 추가 또는 테이블 스페이스 용량 변경
    Made with Material for MkDocs