Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

How to create a locally management temp table space with multiple temp files?

Posted on 2013-06-14
6
Medium Priority
?
832 Views
Last Modified: 2013-06-17
I want to create a locally managed temporary table space with multiple temp files, the database is Oracle 8i. I searched online for a statement, and I was able to find one which is
create temporary tablespace "TEMP3"
tempfile '/ordata/DB_NAME/data/temp_01.dbf' size 100M  autoextend on  next 10M  maxsize 500M
extent management local
uniform size 64K

How I can modify it to allow two or more temp files instead of one?
0
Comment
Question by:alcsoft
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 74

Accepted Solution

by:
sdstuber earned 2000 total points
ID: 39248074
simply list each file separated by commas

CREATE TEMPORARY TABLESPACE temp3 TEMPFILE
    '/oracle/DB_NAME/data/temp_01.dbf' SIZE 100M  AUTOEXTEND ON  NEXT 10M  MAXSIZE 500M,
   '/oracle/DB_NAME/data/temp_02.dbf' SIZE 100M  AUTOEXTEND ON  NEXT 10M  MAXSIZE 500M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 64K;
0
 

Author Comment

by:alcsoft
ID: 39248333
I am getting this error

CREATE TEMPORARY TABLESPACE temp2 TEMPFILE
*
ERROR at line 1:
ORA-01119: error in creating database file '/ordata/DB_NAME /data/temp2_01.dbf'
ORA-27038: skgfrcre: file exists

I dont want to recreate the database.
0
 
LVL 74

Expert Comment

by:sdstuber
ID: 39248346
the error explains the problem, albeit a little cryptically

the file already exists

you'll need to either delete that file (make sure it really is a temp file)
or pick a new file name/location
0
PowerShell Core for Advanced Linux Administrators

Understand advanced principals around Powershell Core with a focus on the Linux Administrator.  This course covers how to administer numerous environments across multiple platforms including Linux, Azure, AWS, and Google Cloud from a single shell instance.

 

Author Comment

by:alcsoft
ID: 39253760
'/ordata/DB_NAME /data/temp2_01.dbf', is not there!!

I changed even the file name and it still giveing me the same error.

skgfrcre: file exists

I think the issue is with the control file skgfrcre!!
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 39253958
I just noticed there is a space after DB_NAME and before the '/'.  That can be the issue.

If not:

Does the PATH exist and does oracle have read/write access?

Post the result from the following OS command:

ls -al /ordata/DB_NAME/data


I have to ask:  Are you replacing DB_NAME with the actual database name?
0
 

Author Comment

by:alcsoft
ID: 39254065
Yes,

Thank you I figured out why it has an issue.
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

662 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question