Home » RDBMS Server » Server Administration » I did not really understand this problem!
I did not really understand this problem! [message #273958] Fri, 12 October 2007 06:22 Go to next message
trantuananh24hg
Messages: 668
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 #273991 is a reply to message #273958] Fri, 12 October 2007 10:53 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Don't put your datafile in autoextend mode.

Regards
Michel
Re: I did not really understand this problem! [message #274041 is a reply to message #273991] Sat, 13 October 2007 00:01 Go to previous messageGo to next message
trantuananh24hg
Messages: 668
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
Thank you, Michael!

And, with the default tablespace USERS created as "Segment Space Management Auto". Can I change it to Local Uniform size without Segment Space Management?



Re: I did not really understand this problem! [message #274051 is a reply to message #274041] Sat, 13 October 2007 02:14 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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

Re: I did not really understand this problem! [message #274054 is a reply to message #274051] Sat, 13 October 2007 02:52 Go to previous message
trantuananh24hg
Messages: 668
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
Thank you for your advice!
Previous Topic: while connect sqlplus "/as sysdba" like this, i got message ORA-01031: insufficient privil
Next Topic: what was the parameter before it has been changed
Goto Forum:
  


Current Time: Sat Dec 03 08:01:16 CST 2016

Total time taken to generate the page: 0.16136 seconds