| |
Posted: Feb 20, 2008 01:01:13 AM |
Total Post: 46
Joined: Sep, 2007
|
Plz help me to give the following question ans.
1. If my temporary tablespace size becomes full what will be my next step?
2. How I reduce the raw migration problem?
3. i have 20GB tablespace and which contains 4 datafile each is 5 GB,and i want to increase the size of the tablespace ?how i will do?
should i write this way?
ALTER TABLESPACE xyz ADD DATAFILE 'C:\XYZ\X_O5.DBF' RESIZE 10GB
is it right ?
plz give me the answer of the 3 question plz.
Thanks & Regards
Dwaipayan Das
|
|
|
 ramesh |
| Posted: Feb 20, 2008 01:40:23 AM |  |
|
Total Post: 40
Joined: Aug, 2007
|
Hellow,
if your temp tablespace becomes full you can alter by using autoexetent on or create another temp tablespace and make it as default temp tablespace which by specifying according to your size.if u r using oracle 10g u just create a temp tablespace and u can add it to temp tablespace groups.
For increasing the Tablespace size u can use by storage parameters (for eg:)
alter tablespace tbsname 'path' storage(intial 1k next2k max extents 10);
|
|
|
|
|
| |
| Posted: Feb 20, 2008 01:59:22 AM | |
|
Total Post: 46
Joined: Sep, 2007
|
Thanks a lot Ramesh.
But if someone using the temporary tablespace in that case can i increase the size of the temporary table space?
|
|
|
|
|
| Mohammed Taj |
| Posted: Feb 20, 2008 02:39:11 AM | |
|
Total Post: 746
Joined: Jul, 2007
|
1. If my temporary tablespace size becomes full what will be my next step?
Nothing, just left on Oracle Server.
2. How I reduce the raw migration problem?
it is row migration ? http://www.akadia.com/services/ora_chained_rows.html
3. i have 20GB tablespace and which contains 4 datafile each is 5 GB,and i want to increase the size of the tablespace ?how i will do?
should i write this way?
ALTER TABLESPACE xyz ADD DATAFILE 'C:\XYZ\X_O5.DBF' RESIZE 10GB
is it right ?
Yes it is right,
but what is need to create one more file with 5 gb?
|
|
|
|
|
| |
| Posted: Feb 20, 2008 03:41:21 AM | |
|
Total Post: 46
Joined: Sep, 2007
|
But if someone using the temporary tablespace in that case can i increase the size of the temporary table space?
|
|
|
|
|
| Kaiz |
| Posted: Feb 20, 2008 10:29:18 AM | |
|
Total Post: 104
Joined: Sep, 2007
|
As far as your 3rd question is concerned friend....
there is one more way you can increase the size of the tablespace by resizing it....
alter database datafile 'path\nameoffile' resize newsizeinKorM;
I hope it will help u...
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
