Home » RDBMS Server » Server Administration » Data file size limit (merged)
Data file size limit (merged) [message #217249] Thu, 01 February 2007 05:42 Go to next message
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 Go to previous messageGo to next message
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: size limit [message #217253 is a reply to message #217249] Thu, 01 February 2007 05:57 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Check the docs.
Re: data file size limit [message #217254 is a reply to message #217251] Thu, 01 February 2007 05:59 Go to previous message
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

Previous Topic: Cannot stop or kill backup job
Next Topic: ora-04031
Goto Forum:
  


Current Time: Tue Aug 22 00:40:36 CDT 2017

Total time taken to generate the page: 0.10035 seconds