Quick Search:
 Oracle PL/SQL: Instant Test Database with DCBA Jump to:  
Category: >> Oracle PL/SQL >> Instant Test Database with DCBA  

<< lastnext >>

Snippet Name: Instant Test Database with DCBA

Description: DBCA is what you need to create a test database in only 5 mins.

Boss: "I want a database to test the new application, do it ASAP!"

You, 5 minutes later: "Boss, here's your database!"

DBCA enables you to perform the following tasks:

- Creating a Database with DBCA
- Configuring Database Options with DBCA
- Deleting a Database with DBCA
- Managing Templates with DBCA
- Configuring Automatic Storage Management with DBCA

Online Help is available by clicking Help. It provides information that guides you in selecting configuration options.

Starting DBCA

To launch DBCA:

1) Log on to your computer as a member of the administrative group that is authorized to install Oracle software and create and run the database.

2) To launch DBCA on a Windows operating system, click Start and then select Programs, Oracle - home_name, Configuration and Migration Tools, and then Database Configuration Assistant.

To launch the DBCA on UNIX, or as another method on a Windows operating system, enter the following command at a system prompt:


The dbca utility is typically located in ORACLE_HOME/bin.

Also see:
» Add PSOUG Search to SQL Developer
» Converting Rows to Columns
» Database Links: CURRENT_USER
» Show info on current context
» Lookup Oracle error messages
» Display and release DBMS_LOCK locks
» Display locks and latches
» Show rollback segment stats
» Show active transactions
» List supported INIT.ORA parameters
» Display database SGA statistics
» Measure the Buffer Cache Hit Ratio
» List security related profile informat...
» Find users with deadly privileges
» Audit User Logins (User Login Trigger)
» Block TOAD and other tools
» Kill Session
» Extents
» DBA Users
» DBA Tablespaces
» DBA triggers
» DBA Sessions
» DBA Roles
» DBA Objects
» DBA Links
» DBA Jobs
» Job Queue
» DBA Free Space
» Data Files
» DBA Extents

Comment: (none)

Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: March 05th, 2009

dbca -Silent -CreateDatabase -gdbName $you_oracle_db_name 
-templateName $template_name [-characterSet] 
[-nationalCharacterSet] [-datafileDestination] 
[-databaseType] ....
-- This command should all be on ONE line!
C:\>%oracle_home%\bin\dbca -Silent -createDatabase -gdbName 
myoracle -templateName %oracle_home%\assistants\dbca\templates\General_Purpose.dbc 
-characterSet WE8MSWIN1252 -nationalCharacterSet ALU32UTF16 
-datafileDestination c:\temp -databaseType MULTIPURPOSE
Copying database files
1% complete
3% complete
11% complete
18% complete
26% complete
37% complete
Creating AND starting Oracle instance
40% complete
45% complete
50% complete
55% complete
56% complete
57% complete
60% complete
62% complete
Completing Database Creation
66% complete
70% complete
73% complete
85% complete
96% complete
100% complete
Look AT the LOG file "c:\oracle\product\1020\cfgtoollogs\dbca\myoracle\myoracle0.log" 
FOR further details.

   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org