일 | 월 | 화 | 수 | 목 | 금 | 토 |
---|---|---|---|---|---|---|
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
- MSSQL
- oracle SCN
- ora-28002: the password will expire within 7 days
- oracle hugepage
- oracle tde
- oracle client 환경변수
- oracle client 설치
- oracle install
- ora-39083 ora-00439
- ORA-00020
- oracleasm
- Oracle RAC
- sqlnet.allowed_logon_version_client=8
- oracle dba_profile password_life_time
- mssql database 삭제
- oracle
- TWO_TASK
- oracle pdb
- sqlnet.allowed_logon_version_server=8
- window pscp
- oracle sqlnet.ora
- SQL Server
- oracle client install
- 오라클
- SSMS
- oracle awr
- window scp
- Oracle Database
- ora-28040: no matching authentication protocol
- window에서 linux로 scp 하는 방법
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