william750214
- 浏览: 305488 次
- 性别:
- 来自: 上海
-
文章分类
- 全部博客 (167)
- <HTML and JavaScript and CSS> (6)
- 《Java2 基础知识及概念》 (3)
- Java2 Tools及其他 (11)
- EJB2.0 相关 (3)
- 英语学习 (4)
- Oracle Database Server (27)
- 计算机理论 (9)
- Java持久层框架 (2)
- 《Linux操作系统》 (24)
- 杂项技术 (4)
- Application Server (15)
- Windows操作系统 (7)
- Java中间件 (6)
- 娱乐生活 (4)
- 《Java设计模式》 (3)
- 《Interview Skill》 (1)
- 《Struts原理及应用》 (1)
- Workflow (2)
- 云计算 (3)
- 项目实践 (3)
- WEB相关技术 (10)
- JavaScript技巧及应用 (1)
最新评论
- Operating System Environment
ORACLE_BASE(NT) c:\oracle
ORACLE_HOME(NT) c:\oracle\ora90
ORACLE_SID
ORA_NLS33
PATH
LD_LIBRARY_PATH - Preparing the Parameter File
(1) Create the new initSID.ora
$ cp init.ora $ORACLE_HOME/dba/initdb01.ora
(2) Modify the initSID.ora
db_name=db01
control_files
db_block_size=8192
#text_enable=true
(3) Create instance (Windows platform)
oradim -NEW -SID db01 -INTPWD admin -pfile='...'
(4) Create SPFILE
create spfile from pfile - Starting the Instance
(1) connect as SYSDBA
(2) startup nomount - Post run scripts in %ORACLE_HOME/rdbms/build_db.sql
分享到：
发表评论
文章已被作者锁定，不允许评论。
-
Oracle忘记数据库密码
2011-07-01 23:45 777alter user xxx identified by xx ... -
Oracle内存全面分析
2010-07-07 16:49 869http://www.hellodba.com/Doc/ora ... -
(15)Managing User
2010-07-07 13:59 854SQL> alter user xxx quo ... -
(14) Managing Password Security and Resources
2010-07-07 13:59 769Password Management SQL> ... -
(13) Managing Data Integrity
2010-07-07 13:58 758... -
(12) Managing Indexes
2010-07-07 13:58 750a -
(11)Managing Table
2010-07-07 13:57 823Storing User Data(1) Regular t ... -
(10) Managing Undo Data
2010-07-07 13:56 808show parameter undo; ... -
(9) Storage Structure and Relationships
2010-07-07 13:55 987Extent Allocat ... -
(8) Managing Tablespaces and Data files
2010-07-07 13:55 1106SQL> select * from v$tabl ... -
(7) Maintaining Redo Log Files
2010-07-07 13:54 1154SQL> select * from v$lo ... -
(6) Maintaining Control file
2010-07-07 13:54 719select * from v$database; se ... -
(5)Data Dictionary Content and Usage
2010-07-07 13:53 1024Data Dictionary(1) Data Dictio ... -
(3)Manage a Oracle Instance
2010-07-07 13:39 820Init Parameter Start Sequences ... -
（2）Getting Start With the Oracle Server
2010-07-07 11:24 805Interactive Installation$ ./r ... -
《Oracle视频教程》
2010-07-07 11:23 22521. Oracle Architectural Compone ... -
Oracle EXP/IMP命令详解
2010-07-07 10:01 1086EXP命令 格式: EXP KEYWORD=value ... -
Oracle EXP Direct
2010-07-07 10:00 1248Oracle提供2种模式导出表数据，传统模式CONVENTIO ... -
EXPDP和IMPDP使用说明
2010-07-07 09:53 1059EXPDP命令行选项 1. ATTACHexpd ... -
Oracle GoldenGate备份软件
2010-07-05 13:46 2575转载：http://edu.codepub.com/2010/ ...
相关推荐
How to Create a Database in Python using SQL Lite 3 英文epub 本资源转载自网络，如有侵权，请联系上传者或csdn删除 查看此书详细信息请在美国亚马逊官网搜索此书
The code is for automatically randomly create database
How to Create a Database in Python using SQL Lite 3 英文mobi 本资源转载自网络，如有侵权，请联系上传者或csdn删除 查看此书详细信息请在美国亚马逊官网搜索此书
How to Create a Database in Python using SQL Lite 3 英文azw3 本资源转载自网络，如有侵权，请联系上传者或csdn删除 查看此书详细信息请在美国亚马逊官网搜索此书
How to Create a Database in Python using SQL Lite 3 英文无水印转化版pdf pdf所有页面使用FoxitReader、PDF-XChangeViewer、SumatraPDF和Firefox测试都可以打开 本资源转载自网络，如有侵权，请联系上传者或...
Six-Step Relational Database DesignTM uses three case studies and starts with a statement of the problem by the client and then goes through the six steps necessary to create a reliable and accurate ...
你需要知道一些关键的SQL命令，例如创建表格(Create Table)、从表中选择数据(Select...From...Where)、插入数据(Insert Into)、删除数据(Delete)和更新数据(Update)。 Python与数据库的结合使用中，SQLite3随Python...
How To Drop, Create And Recreate DB Control In A 10g Database [ID 278100.1] Metalink上下载
create public database link test_default_type_dblink using 'zytydic'; ``` 此时，如果当前用户是在本地数据库`db_A`上以`emcd`用户登录的，那么创建的`DBLink` `test_default_type_dblink` 将使用相同的...
在编程领域，Easy4App（E4A）是一款流行的安卓应用开发工具，它允许开发者用简单的编程语言来创建安卓应用程序。在E4A中，数据库的管理是应用程序功能的重要组成部分，尤其是在处理用户数据、实现数据存储和检索时。...
《A First Courses in Database Systems》是一本广泛使用的数据库系统基础教程，涵盖了数据库设计、SQL语言、关系模型、事务处理和并发控制等多个关键领域。本资料提供了该教程的习题答案，帮助读者深入理解和掌握...
The 11th edition of Database Processing refines the organization and content of this classic textbook to reflect a new teaching and professional workplace environment. The organization and topic ...
create database CONTROLFILE REUSE MAXINSTANCES 8 MAXDATAFILES 100 MAXLOGHISTORY 1 MAXLOGFILES 16 MAXLOGMEMBERS 5 characterset ZHS16GBK national characterset AL16UTF16 logfile group 1 ('/home/...
Through BDB, you can design a new database, automatically create or renew to an entity database. Through BDB you can also derive existing database and create an automatically installing program of ...
Through BDB, you can design a new database, automatically create or renew to an entity database. Through BDB you can also derive existing database and create an automatically installing program of ...
The training kit takes you through the steps of how to plan and implement a database, create and maintain database objects, and implement data integrity. You will also be introduced to Transact-SQL, ...
Analyses a database and writes the code required to create blank copy. Two projects dbCoderAddIn.vbp can be compiled as an add-in and will place the code in a new module of the active project.
在创建Oracle数据库的过程中，手动执行CREATE DATABASE命令是一种常见且重要的方法，特别是在高级认证如OCM的实验考试中。以下是创建Oracle数据库的详细步骤和相关知识点： 1. **创建参数文件和口令文件**： - ...
Absolute Database Manager to manage a database easily and to perform all supported operations with tables and database file Absolute Database Manager also provides you an easy way of executing SQL ...