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: 310
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: 310
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: MMON is generating lot of logs
Next Topic: Regarding DBMS job
Goto Forum:
  


Current Time: Fri Dec 09 00:02:12 CST 2016

Total time taken to generate the page: 0.08692 seconds