| I did not really understand this problem! [message #273958] |
Fri, 12 October 2007 06:22  |
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
|
Senior Member |
|
|
Dear all!
For the large dump file that is about 40GB, however, it's serious for me. All of the schema objects were put in only tablespace - U SERS.
My first hard disk does not support to 200GB, and the datafile USER.DBF was already 40GB. This was the reason which I decided to add datafile into tablespace USERS, this was on the different hard disk - the second hard disk. Now, the tablespace USERS has 3 datafiles with total size was 180GB.
Unfortunately, when I imported the dump file into database, only datafile which was in primary disk increased, the others did not. When the first - default datafile in primary disk was full, it - the import progress stopped.
I did not really understand what happened? Were I wrong?
Please help me!
Thank you very much!
[Updated on: Fri, 12 October 2007 06:25] Report message to a moderator |
|
|
|
|
|
|
|
| Re: I did not really understand this problem! [message #274051 is a reply to message #274041] |
Sat, 13 October 2007 02:14  |
 |
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
You can't change any structural parameters of tablespace without recreating it.
You can't have "Segment Space Management Auto" if your tablespace is not LMT. You can't switch from auto to manual or the opposite without recreating the tablespace (or better, create a new tablespace, move the objects, drop the old tablespace).
Regards
Michel
[Updated on: Sat, 13 October 2007 03:48] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
