D:\>set oracle_sid=fodder
>
> D:\>sqlplus /nolog
>
> SQL*Plus: Release 10.1.0.3.0 - Production on Fri Feb 18 20:15:26 2005
>
> Copyright (c) 1982, 2004, Oracle. All rights reserved.
>
> SQL> connect / as sysdba
> Connected to an idle instance.
> SQL> shutdown abort;
> ORACLE instance shut down.
> SQL> startup nomount;
> ORACLE instance started.
>
> Total System Global Area 612368384 bytes
> Fixed Size 790352 bytes
> Variable Size 174321840 bytes
> Database Buffers 436207616 bytes
> Redo Buffers 1048576 bytes
>
> SQL> alter database mount exclusive;
>
> Database altered.
>
> SQL> alter system enable restricted session;
>
> System altered.
>
> SQL> drop database;
>
> Database dropped.
>
> Disconnected from Oracle Database 10g Release 10.1.0.3.0 - Production
> SQL> quit
create new database file using OMF
SQL> conn / as sysdba
SQL> startup nomount;
SQL> alter system set db_create_file_dest='D:\oracle\product\10.0.2.0\oradata\newdb\';
SQL> create database;
SQL> alter database open;
OK
相关推荐
Oracle was supposed to do and how to do it efficiently. There weren’t many options, so there weren’t many ways to do things wrong. But how do you get started today when the core of Oracle is hidden...
Overview Absolute Database: Delphi database with SQL support.Absolute Database lets you forget the Borland Database Engine (BDE). This BDE replacement is the compact, high-speed, robust and easy-to-...
How to use Java Database Connectivity (JDBC) to connect and integrate with various MySQL, Oracle, and NoSQL databases How to work with internationalization, localization and more How to effectively ...
How to use Java Database Connectivity (JDBC) to connect and integrate with various MySQL, Oracle, and NoSQL databases How to work with internationalization, localization and more How to effectively ...
o Added drag And drop icon in the toolbar that allows to to easily filter by the desired application. Simply drag the target icon into the window of the application, and CurrPorts will display only...
You can use the editor preferences to configure when and how items are added to and deleted from the PL/SQL Clipboard. Debugger Enhancements You can now display compound variable values such as user-...
You can use the editor preferences to configure when and how items are added to and deleted from the PL/SQL Clipboard. Debugger Enhancements You can now display compound variable values such as user...
You can use the editor preferences to configure when and how items are added to and deleted from the PL/SQL Clipboard. Debugger Enhancements You can now display compound variable values such as user-...
You can use the editor preferences to configure when and how items are added to and deleted from the PL/SQL Clipboard. Debugger Enhancements You can now display compound variable values such as user...
see How to Decorate Components with JLayer. The Nimbus Look and Feel has been moved from the com.sun.java.swing package to the javax.swing package; see the javax.swing.plaf.nimbus package. Mixing ...