| Data file size limit (merged) [message #217249] |
Thu, 01 February 2007 05:42  |
maoro
Messages: 312
Registered: May 2005
|
Senior Member |
|
|
hello
yhanks for support
you mean i can create a 100gb datafile on windows or unix with no problem, and what is the bigfile tablespace in 10g
thanks
|
|
|
|
| data file size limit [message #217251 is a reply to message #217249] |
Thu, 01 February 2007 05:44  |
maoro
Messages: 312
Registered: May 2005
|
Senior Member |
|
|
hello
what is the datafile size limit on windows based systems and on unix based systems, another question :
"alter system set something=something" by default the scope is memory or it updates the spfile also;
thanks alot
|
|
|
|
|
|
| Re: data file size limit [message #217254 is a reply to message #217251] |
Thu, 01 February 2007 05:59 |
 |
ebrian
Messages: 2794
Registered: April 2006
|
Senior Member |
|
|
| maoro wrote on Thu, 01 February 2007 06:44 |
what is the datafile size limit on windows based systems and on unix based systems
|
Check your other post.
| maoro wrote on Thu, 01 February 2007 06:44 |
"alter system set something=something" by default the scope is memory or it updates the spfile also;
|
Default is BOTH if you used an spfile to start the instance and MEMORY if you used an init file. Again, it's in the docs.
[Updated on: Thu, 01 February 2007 06:03] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
