Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2009
    Posts
    55

    Unanswered: error for create temptable space

    Hi,
    I use below command to create database in oracle 9
    CREATE DATABASE rman1
    USER SYS IDENTIFIED BY rman1
    USER SYSTEM IDENTIFIED BY rman1
    LOGFILE GROUP 1 ('/database/oradata_rman1/rman1/redo01.log') SIZE 100M,
    GROUP 2 ('/database/oradata_rman1/rman1/redo02.log') SIZE 100M,
    GROUP 3 ('database/oradata_rman1/rman1/redo03.log') SIZE 100M
    MAXLOGFILES 5
    MAXLOGMEMBERS 5
    MAXLOGHISTORY 1
    MAXDATAFILES 100
    MAXINSTANCES 1
    CHARACTER SET US7ASCII
    NATIONAL CHARACTER SET AL16UTF16
    DATAFILE '/database/oradata_rman1/rman1/system01.dbf' SIZE 325M REUSE
    EXTENT MANAGEMENT LOCAL
    DEFAULT TEMPORARY TABLESPACE tempts1
    DATAFILE '/database/oradata_rman1/rman1/temp01.dbf'
    SIZE 20M REUSE
    UNDO TABLESPACE undotbs
    DATAFILE 'database/oradata_rman1/rman1/undotbs01.dbf'
    SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED;
    But I get error
    ERROR at line 17:
    ORA-25139: invalid option for CREATE TEMPORARY TABLESPACE

    What is wrong ???

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Something is missing...

    Code:
    -- etc --
    DEFAULT TEMPORARY TABLESPACE tempts1
    TEMPFILE '/database/oradata_rman1/rman1/temp01.dbf' 
    --   ^-- Wrong name?
    SIZE 20M REUSE
    UNDO TABLESPACE undotbs 
    DATAFILE '/database/oradata_rman1/rman1/undotbs01.dbf'
    --        ^-- missing '/'?
    -- etc --
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  3. #3
    Join Date
    Aug 2009
    Posts
    55
    Hi,
    I edit the comand and use below
    I still get error ?? why ?? please advice ???

    CREATE DATABASE rman1
    USER SYS IDENTIFIED BY rman1
    USER SYSTEM IDENTIFIED BY rman1
    LOGFILE GROUP 1 ('/database/oradata_rman1/rman1/redo01.log') SIZE 100M,
    GROUP 2 ('/database/oradata_rman1/rman1/redo02.log') SIZE 100M,
    GROUP 3 ('/database/oradata_rman1/rman1/redo03.log') SIZE 100M
    MAXLOGFILES 5
    MAXLOGMEMBERS 5
    MAXLOGHISTORY 1
    MAXDATAFILES 100
    MAXINSTANCES 1
    CHARACTER SET US7ASCII
    NATIONAL CHARACTER SET AL16UTF16
    DATAFILE '/database/oradata_rman1/rman1/system01.dbf' SIZE 325M REUSE
    EXTENT MANAGEMENT LOCAL
    DEFAULT TEMPORARY TABLESPACE tempts1
    TEMPFILE '/database/oradata_rman1/rman1/temp01.dbf'
    SIZE 20M REUSE
    UNDO TABLESPACE undotbs
    DATAFILE '/database/oradata_rman1/rman1/undotbs01.dbf'
    SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED;

    ERROR at line 1:
    ORA-01092: ORACLE instance terminated. Disconnection forced


    SQL> startup;
    ORA-24324: service handle not initialized
    ORA-01041: internal error. hostdef extension doesn't exist

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >why ??
    Prerequisites not met.

    >please advice ???
    Research error & fix problem
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Aug 2009
    Posts
    55
    Hi,
    I create new database rman1 and get below error
    please advice how to fix ??/

    SQL> CREATE DATABASE rman1
    2 LOGFILE GROUP 1 ('/database/oradata_rman1/rman1/redo01.log') SIZE 100M,
    GROUP 2 ('/database/oradata_rman1/rman1/redo02.log') SIZE 100M,
    GROUP 3 ('/database/oradata_rman1/rman1/redo03.log') SIZE 100M
    3 4 5 MAXLOGFILES 5
    6 MAXLOGMEMBERS 5
    MAXLOGHISTORY 1
    MAXDATAFILES 100
    7 8 9 MAXINSTANCES 1
    10 CHARACTER SET US7ASCII
    11 NATIONAL CHARACTER SET AL16UTF16
    12 DATAFILE '/database/oradata_rman1/rman1/system01.dbf' SIZE 325M REUSE
    13 EXTENT MANAGEMENT LOCAL
    14 DEFAULT TEMPORARY TABLESPACE tempts1
    TEMPFILE '/database/oradata_rman1/rman1/temp01.dbf'
    15 16 SIZE 20M REUSE
    UNDO TABLESPACE undotbs
    17 18 DATAFILE '/database/oradata_rman1/rman1/undotbs01.dbf'
    19 SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED;
    CREATE DATABASE rman1
    *
    ERROR at line 1:
    ORA-01092: ORACLE instance terminated. Disconnection forced

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •