SCH Document
01688
검색 초기화
    GitHub
    GitHub
    • Home
    • Ai
      • Prompt
    • Aws
      • 1. Library and AWS CLI (aptget for Node Image)
      • Athena
      • Cdk
        • Example
      • Cli
      • Cloudformation
      • Dms
        • Oracle
        • Postgresql
      • Elb
      • Glue
      • Iam
      • Rds
        • Aurora
          • Info
        • Mysql
          • Create instance
          • Log
          • Optimized writes
        • Oracle
          • Administering
          • Create instance
          • Datapump
          • Memory swap
          • Quotas
          • S3
            • S3 INTEGRATION
          • Spatial
          • Temporary tablespace
          • Timezone
        • Postgresql
      • S3
      • Snapshot
      • [Session Manager](https://ap-northeast-1.console.aws.amazon.com/systems-manager/session-manager/sessions?region=ap-northeast-1#)
    • 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
    • Linux
      • CentOS-Base.repo
      • HugePage
      • inode
      • Transparent HugePages
    • Mysql
      • Error
      • Parameter
      • Analyze
      • Cast
      • Cluster
        • Innodb
        • Ndb
      • 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
      • Hugepage
      • Index
      • Insert into on duplicate key update
      • Install
      • Isolation level
      • Load data
      • Log
        • Binary
        • General
        • Relay
        • Slow query
      • Mysql
      • Mysql shell
      • Mysql shell dump
      • Mysqlbinlog
      • Mysqld
      • Mysqldump
      • Mysqldump pump dumper shell
      • 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
      • Replication
        • Master replication
        • Mha
        • Semi sync replication
      • Router
      • Schema
      • Spatial
      • Sql mode
      • Table
      • Tablespace
        • System
      • Time zone
      • User
      • View
    • Oracle
      • Error
      • Parameter
      • favorite
      • Active duplication
      • Analyze
        • Analyze와 DBMS_STATS의 차이
      • Automated maintence task
      • Automatic memory management
      • 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 index
        • Oracle text index
          • Oracle Text에 대한 자세한 설명
          • Oracle Text 인덱스와 % 의 성능 비교
      • Install oracle client
      • Latch
        • Cache Buffers Chains
        • Library Cache
      • Literal sql
      • Lob
      • Log
        • Archive
        • Supplemental
        • 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
        • Awr
        • Statspack
      • Row level lock
      • Sequence
      • Session
      • Shrink
      • Sqlldr
      • Sqlplus
      • Synonym
      • Table
        • Temporary table
      • Tablespace
        • BIGFILE과 SMALLFILE의 차이
        • 테이블 스페이스 내부 데이터 크기를 확인하여 변경
        • Temporary Tablespace
        • UNDO Tablespace
      • Trigger
      • User
      • View
        • Materialized view
      • With
    • Postgresql
      • Parameter
      • Cluster
        • Patroni
        • Pgbackrest
      • Database
      • Extension
        • Dblink
        • Oracle fdw
      • Install
      • Pg ctl
      • pg_dump
      • Pgbadger
      • Pgbench
      • Psql
      • Schema
      • Sequence
      • Serial
      • Server
      • Session
      • Timezone
      • User
      • User mapping
    • python
      • Breakpoint
      • Datetime
      • Error
        • ERROR: Could not install packages due to an OSError: [Errno 13] Permission denied: 'c:\python39\Scripts\pywin32_postinstall.py' Consider using the --user option or check the permissions.
        • AttributeError
        • IndentationError: unexpected indent
        • TypeError
      • Json
      • Time
    • Shell
      • crontab
      • export
      • find
      • grep
      • head
      • iconv
      • iostat
      • journald
      • 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