Oracle Database Server
文章平均质量分 65
iteye_447
这个作者很懒,什么都没留下…
展开
-
用Java实现磁盘文件以大对象二进制文件形式存储到Oracle数据库
BLOB blob = null; PreparedStatement pstmt = conn.prepareStatement("insert into javatest(name,context) values(?,empty_blob())"); pstmt.setString(1,""+list.get(i).toString()+""); ...原创 2009-02-09 02:33:58 · 168 阅读 · 0 评论 -
(5)Data Dictionary Content and Usage
Data Dictionary(1) Data Dictionary tables Base tables: 加密,只读 Data Dictionary View(2) Dynamic performance tables Data Dictionary View Categories(1) DBA(2) ALL(3) USER Query(1) select * from ...原创 2010-07-07 13:53:20 · 75 阅读 · 0 评论 -
(6) Maintaining Control file
select * from v$database; select * from v$tablespace; select * from v$archived_log; alter database backup controlfile to 'c:\controlfile.bak'; alter database backup controlfile to trace; (...原创 2010-07-07 13:54:01 · 64 阅读 · 0 评论 -
(7) Maintaining Redo Log Files
SQL> select * from v$log (status: current/active/inactive/unused)SQL> select * from v$logfile (status: blank(in use)/stale(incomplete)/delete)Force log switch and CKPTSQL> alter s...原创 2010-07-07 13:54:33 · 81 阅读 · 0 评论 -
(8) Managing Tablespaces and Data files
SQL> select * from v$tablespace;SQL> select * from v$datafile;SQL> select * from v$tempfile;SQL> select t1.name,t2.name from v$tablespace t1, v$datafile t2 where t1.ts#=t2.ts#;SQL > ...原创 2010-07-07 13:55:08 · 91 阅读 · 0 评论 -
(9) Storage Structure and Relationships
Extent Allocation and DeallocationSQL> alter table xxx allocation extent (size 1m datafile 'xxx');SQL> alter table xxx deallocation unused; Database Block(1) set at tabl...原创 2010-07-07 13:55:41 · 65 阅读 · 0 评论 -
(10) Managing Undo Data
show parameter undo; SQL> alter tablespace xxx offline (immediate,temporary or for recovery)SQL>recover datafile 'xxx'SQL> show parameter undo NAME ...原创 2010-07-07 13:56:11 · 72 阅读 · 0 评论 -
(11)Managing Table
Storing User Data(1) Regular table(2) Partitioned table(3) Index-organized table(4) Cluster ROWID: 18位,64进制的字符串 (内部10bytes,80bit)object# 32bits rfile# 10bits block# 22bits...原创 2010-07-07 13:57:06 · 67 阅读 · 0 评论 -
(12) Managing Indexes
a原创 2010-07-07 13:58:18 · 65 阅读 · 0 评论 -
(13) Managing Data Integrity
SQL> alter table xxx add constraint PK_XXX primary key(unid);SQL> alter table xxx add constraint UK_XXX unique(xxx,xxx);SQL> alter table xxx add constr...原创 2010-07-07 13:58:40 · 74 阅读 · 0 评论 -
(14) Managing Password Security and Resources
Password ManagementSQL> alter user xxx account lock(unlock) 显示锁定用户SQL> alter user xxx password expireSQL> create profile profile1 limit failed_login_attempts 3 ...原创 2010-07-07 13:59:12 · 81 阅读 · 0 评论 -
(15)Managing User
SQL> alter user xxx quota 10m on tablespacexxx;Dropping a user SQL> drop user xxx cascade; (不能删除已经连接的)Data Dictionary DBA_USERS DBA_TS_QUOT...原创 2010-07-07 13:59:37 · 67 阅读 · 0 评论 -
(4)Create a Database
Operating System EnvironmentORACLE_BASE(NT) c:\oracleORACLE_HOME(NT) c:\oracle\ora90ORACLE_SIDORA_NLS33PATHLD_LIBRARY_PATH Preparing the Parameter File(1) Create the new initSID.ora...原创 2010-07-07 13:52:29 · 82 阅读 · 0 评论 -
(3)Manage a Oracle Instance
Init Parameter Start Sequencespfile<sid>.ora--------spfile.ora-----------init<sid>select * from v$system_parameter 查看所有参数alter system set name=value scope=memory(spfile,both)desc v$sys...原创 2010-07-07 13:39:45 · 77 阅读 · 0 评论 -
(2)Getting Start With the Oracle Server
Interactive Installation$ ./runInstaller Non-Interactive Installation$ ./runInstaller -responsefile myrespfile -silent DBCA Optional Flexible Architecture(OFA) create OS user id: xxxcrea...原创 2010-07-07 11:24:26 · 71 阅读 · 0 评论 -
Oracle数据库实例教程
1. Writing Basic SQL Select StatementsOperator +, - , *, /, () parentheses Nul values在算术表达式中,结果为null desc tablename 查看table structure 2. Restricting and Sorting DataComparision Conidtio...2009-02-21 14:24:40 · 265 阅读 · 0 评论 -
<Oracle 培训视频>~
sqlplussqlpluswhttp://192.168.1.88:5560/isqlplus/ 1. unlock user: alter user scott account unlock; 2. table_structures sql> desc tablename; 查看表结构varchar2 支持国际化 别名中有...原创 2010-01-08 08:35:10 · 84 阅读 · 0 评论 -
Oracle忘记数据库密码
alter user xxx identified by xxx;alter user xxx account unlock; C:\Users\mwang>orapwd file=D:\software\oracle\product\11.1.0\db_1\database\PWDorcl11g.ora password=mwang原创 2011-07-01 23:45:36 · 109 阅读 · 0 评论 -
<Oracle 转义字符>~
1、oracle 特殊字符 转义在plsql里边执行: update userinfo set pageurl='myjsp?page=1&pagesize=10' where id='test' 1) update userinfo set pageurl='myjsp?page=1'||'&'||'pagesize=10' where id='test' 2) up...原创 2010-05-10 16:05:16 · 122 阅读 · 0 评论 -
<PLSQL 入门>~
declarebeginexceptionend SQL> set serveroutput onSQL> begin 2 dbms_output.put_line('Hello world!'); 3 end; 4 /Hello world! SQL> declare 2 v_name varchar2(20);...原创 2010-05-12 13:24:32 · 105 阅读 · 0 评论 -
<如何快速删除大量记录>~
(1) create table xxxtemp as select * from xxx where <conditions> (2) drop table xxx; (3) create table xxx as select * from xxxtemp;原创 2010-05-31 10:58:22 · 78 阅读 · 0 评论 -
Oracle GoldenGate备份软件
转载:http://edu.codepub.com/2010/0607/23329.php 一、前言GoldenGate软件是一种基于日志的结构化数据复制软件,它通过解析源数据库在线日志或归档日志获得数据的增量变化,再将这些变化应用到目标数据库,从而实现源数据库与目标数据库同步。GoldenGate 可以在异构的IT基础结构(包括几乎所有常用操作系统平台和数据库平台)之间实现大量数据亚秒一...原创 2010-07-05 13:46:24 · 191 阅读 · 0 评论 -
EXPDP和IMPDP使用说明
EXPDP命令行选项1. ATTACHexpdp scott/tiger ATTACH=scott.export_jobEXPORT> start_job, stop_job, kill_job, status2. CONTENT该选项用于指定要导出的内容.默认值为ALLCONTENT={ALL | DATA_ONLY | METADATA_ONLY}3. DIRECTO...原创 2010-07-07 09:53:24 · 78 阅读 · 0 评论 -
Oracle EXP Direct
Oracle提供2种模式导出表数据,传统模式CONVENTIONAL PATH和直接模式DIRECT PATH,有direct指定。 CONVENTIONAL PATH EXPORT 比较DIRECT PATH EXPORT 一、差异1. Conventional path Export. ------------------------- 传统导出模式使用SQL SELECT语句抽取...原创 2010-07-07 10:00:32 · 108 阅读 · 0 评论 -
Oracle EXP/IMP命令详解
EXP命令格式: EXP KEYWORD=value 或 KEYWORD=(value1,value2,...,valueN)实例: EXP SCOTT/TIGER GRANTS=Y TABLES=(EMP,DEPT,MGR)或 TABLES=(T1: P1,T1: P2),如果 T1 是分区表USERID 必须是命令行中的第一个参数。关键字 说明(默认)-----------------...原创 2010-07-07 10:01:57 · 75 阅读 · 0 评论 -
《Oracle视频教程》
1. Oracle Architectural Components SQL> show sgaSQL> set wrap offSQL> set linesize 1000SQL> select * from v$bgprocess; paddr <> '00' 必须的后台进程SQL> select * from v...原创 2010-07-07 11:23:34 · 158 阅读 · 0 评论 -
Oracle内存全面分析
http://www.hellodba.com/Doc/oracle_memory(1).htm http://www.hellodba.com/Doc/oracle_memory(2).htm http://www.hellodba.com/Doc/oracle_memory(3).htm http://www.hellodba.com/Doc/oracle_memory...原创 2010-07-07 16:49:25 · 56 阅读 · 0 评论