[ORACLE]/Admin2 Oracle MAX 값 정리 Datatype Limits Datatypes Limit Comments BFILE Maximum size: 4 GB Maximum size of a file name: 255 characters Maximum size of a directory name: 30 characters Maximum number of open BFILEs: see Comments The maximum number of BFILEs is limited by the value of the SESSION_MAX_OPEN_FILES initialization parameter, which is itself limited by the maximum number of open files the operating system will a.. 2012. 7. 19. oracle 11g deferred_segment_created 11g 부터 table 생성시 data가 들어오기 전까지 segment를 만들지 않게 설정 할 수 있습니다. SYS, SYSTEM, PUBLIC, OUTLN, XDB schema는 제외 됩니다. SQL> ALTER SYSTEM SET deferred_segment_creation=TRUE; - conn hyun/hyun SQL> create table deferred_table11(id number(8) CONSTRAINT id_pk_11 primary key); Table created. SQL> select segment_name, segment_type 2 from user_segments 3 where segment_name in ('DEFERRED_TA.. 2012. 1. 13. 이전 1 다음