Solved

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

Posted on 2013-06-14
6
799 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 500 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
Get Database Help Now w/ Support & Database Audit

Keeping your database environment tuned, optimized and high-performance is key to achieving business goals. If your database goes down, so does your business. Percona experts have a long history of helping enterprises ensure their databases are running smoothly.

 

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

Get Database Help Now w/ Support & Database Audit

Keeping your database environment tuned, optimized and high-performance is key to achieving business goals. If your database goes down, so does your business. Percona experts have a long history of helping enterprises ensure their databases are running smoothly.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
How ldap located a Domain controller? 22 78
Intermittent OleDbConnection Error 20 53
DB Shutdown Automatically 11 36
Access Data Retrieval 1 8
As technology users and professionals, we’re always learning. Our universal interest in advancing our knowledge of the trade is unmatched by most industries. It’s a curiosity that makes sense, given the climate of change. Within that, there lies a…
Azure Functions is a solution for easily running small pieces of code, or "functions," in the cloud. This article shows how to create one of these functions to write directly to Azure Table Storage.
Connecting to an Amazon Linux EC2 Instance from Windows Using PuTTY.
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

739 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