Tips for Oracle DBA

Oracle Database Administration, How To, Daily DBA jobs, Oracle Error Cause and Action

Oracle DBA, How To, Error, Cause and Action

Back To Menu

ORA-01946: DEFAULT TABLESPACE already specified

ORA-01946: DEFAULT TABLESPACE already specified

Cause: The default tablespace clause has been given twice.

Action: Use only one default tablespace clause.

Newer Post Older Post Home

Loading

Popular Posts

Password Verification Function
Oracle Database 11g Memory Stucture (SGA & PGA)
ORA-03149: Invalid Oracle error code
ORA-04025: maximum allowed library object lock allocated forstringstringstringstringstring
ORA-03147: Missing mandatory TTC field
Oracle 11g Installation on Enterprise Linux 32-bit (1/5)
Increase Tablespace Size Automatically and Manually
ORA-16086: Redo data cannot be written to the standby redo log
ORA-03179: NOCACHE or ORDER sequences cannot be accessed from Active Data Guard standby
Global Login Script - glogin.sql

7 Types of Files in Oracle Database (1) About e-DBA blogspot (1) Archive Log (1) Archived Redo Log Files (1) Autostart (1) Background Processes (1) Backup Files (1) Basic Parameters (1) Closed (4) concurrency (1) Connection (1) Control Files (1) Create Oracle Database (4) cron (1) Data Dictionary (2) Database Configuration Assistant (4) Database Objects (1) Datafiles (3) Date (1) DB Cache (1) DBA Report (1) DBCA (4) dbora (1) Dictionary Cache (1) Download (1) Extents (1) foreign key (1) Free Space (1) Fun (1) glogin.sql (2) Guideline (3) index (1) Initialization Parameters (1) Java Pool (1) Large Pool (1) Library Cache (1) Linux (7) listener (3) Menu (1) Mount (2) Nomount (6) OEL (7) oerr (1) OFA (1) Online Redo Log Files (1) Open (2) Oracle 11g Installation (5) Oracle Database Block (1) Oracle Database Logical Structure (1) Oracle Enterprise Linux Installation (7) Oracle Exadata (1) Oracle Software (1) Oracle Storage (1) Parameter Files (2) Parameters (1) patch (1) PFILE (1) Pivot (1) Print Table Vertically (1) Private SQL Areas (1) Profile (2) Redo Log Buffer (1) Result Cache (1) Schema (1) Scripts (4) Segment (1) Session (1) SGA (1) Shared Pool (1) Shared SQL Areas (1) Shutdown Abort (1) Shutdown Immediate (1) Shutdown Normal (1) Shutdown Sequence (4) Shutdown Transactional (1) smon (2) SPFILE (1) SQL Query Result Cache (1) SQLPlus (2) Standard (1) Startup Sequence (2) Streams Pool (1) Tablespace (10) Tablespace Usage (1) Undo Data (1) Unix / Linux Command (3) User (1) Utility (1) vi Editor (1) Virtual Server Creation (2) VMware (4) VMware Configuration (9) VMware Installation Step by Step (2) VMware Software (1)

Hayley Erin Xing © 2013. Powered by Blogger.