| How to designate a file for use [message #188759] |
Mon, 21 August 2006 09:30  |
Jack_zhai
Messages: 12
Registered: February 2006
|
Junior Member |
|
|
Hi,
Regularly, when I want to use multiple files for one tablespaces, I am going to turn the first few data files autoextensible to "NO". Just leave the last file's autoextensible as "YES". Then when new object is created in that tablespace, it will go the the last file. Then I can control the size of the data files. Today, I checked another database, I found there were five files in one tablespace. I am wodering how it is done ?
Thanks
Jack
|
|
|
|
|
|
| Re: How to designate a file for use [message #188966 is a reply to message #188763] |
Tue, 22 August 2006 10:48  |
Jack_zhai
Messages: 12
Registered: February 2006
|
Junior Member |
|
|
Hi,
I know that I just can designate a tablespace for the object not a file. But I saw our oracle financial system used five files for system tablespace and the extensible are "YES". I am wondering how did they do it ?
Thanks
Jack
|
|
|
|
| Re: How to designate a file for use [message #188968 is a reply to message #188966] |
Tue, 22 August 2006 10:52 |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
>>But I saw our oracle financial system used five files for system tablespace and the extensible are "YES". I am wondering how did they do it ?
Alter database datafile '/path/systemdatafile_1.dbf' autoextend on;
Alter database datafile '/path/systemdatafile_2.dbf' autoextend on;
Alter database datafile '/path/systemdatafile_3.dbf' autoextend on;
...
...
And you can have multiples datafiles for the same tablespace
[Updated on: Tue, 22 August 2006 10:53] Report message to a moderator |
|
|
|
| Re: How to designate a file for use [message #188993 is a reply to message #188759] |
Tue, 22 August 2006 12:45 |
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
|
Senior Member |
|
|
| Jack_zhai wrote on Mon, 21 August 2006 10:30 |
Hi,
Regularly, when I want to use multiple files for one tablespaces, I am going to turn the first few data files autoextensible to "NO".
|
Then
| Quote: |
Today, I checked another database, I found there were five files in one tablespace. I am wodering how it is done ?
|
I don't understand. You first claim you "regularly" use multiple files in on tablespace, then you are confused that another database has multiple files for a tablespace. Huh? Are you asking how to add datafiles to a tablespace?
alter tablespace data_t1 add datafile '/vol00/ORCL/data_t1_2.dbf' size 1000m autoextend on; |
|
|
|
| Re: How to designate a file for use [message #189487 is a reply to message #188993] |
Thu, 24 August 2006 15:55 |
Jack_zhai
Messages: 12
Registered: February 2006
|
Junior Member |
|
|
May be my explanation was not clear.
what I was saying is let us say, there are two files file1 and file2 for tablespace tsp1. If I keep file1 and file2 both as extensible, then when I insert data to the tsp1, all the data will be inserted to file1 which added to the tsp1 first. In order to insert data to file2, I have to change file1 as not extensible. What I am confusing is , I saw file1 and file2 both extensible but both have a certain mount of data in them. How does that happen ?
Thank
Jack
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
