일 | 월 | 화 | 수 | 목 | 금 | 토 |
---|---|---|---|---|---|---|
1 | 2 | 3 | 4 | 5 | ||
6 | 7 | 8 | 9 | 10 | 11 | 12 |
13 | 14 | 15 | 16 | 17 | 18 | 19 |
20 | 21 | 22 | 23 | 24 | 25 | 26 |
27 | 28 | 29 | 30 | 31 |
Tags
- window에서 linux로 scp 하는 방법
- 오라클
- oracle client 환경변수
- oracle
- ora-28040: no matching authentication protocol
- oracle install
- ORA-00020
- oracle dba_profile password_life_time
- sqlnet.allowed_logon_version_client=8
- ora-28002: the password will expire within 7 days
- oracle SCN
- sqlnet.allowed_logon_version_server=8
- ora-39083 ora-00439
- Oracle Database
- oracleasm
- window pscp
- oracle client 설치
- SQL Server
- oracle tde
- oracle pdb
- Oracle RAC
- TWO_TASK
- MSSQL
- SSMS
- oracle client install
- window scp
- oracle hugepage
- oracle sqlnet.ora
- mssql database 삭제
- oracle awr
Archives
- Today
- Total
신문지한장
[SQL] oracle 파티션 테이블 생성 및 조회
OS : CentOS 7.9 DB : Oracle Database 19c(19.23.0) 1. 파티션 테이블 생성SQL>create table ptable(col1 varchar2(8),col2 number)tablespace userspartition by range (col1)(partition p202101 values less than ('20210200'),partition p202102 values less than ('20210300'),partition p202103 values less than ('20210400'),partition p202104 values less than ('20210500'),partition p202105 values less than ('20210600'),..
Oracle/sql&script
2024. 12. 2. 15:58