Home » Server Options » RAC & Failsafe » urgent pl........
urgent pl........ [message #74815] Sat, 27 July 2002 04:31 Go to next message
shaheena
Messages: 17
Registered: February 2002
Junior Member
hello;
it is very urgent will you pl give me the answers of following questions
i request you to pl don't misguide me ,give accurate answers.
1-what ia the default size of an oracle block(in 9i)?
2-how many tablespaces we can create in a database(in 9i)?
3-how many datafiles are allowed in each tablespace?
4-maximum datafiles allowed in the database?
5-how can we add a diffrent size logfile member in an already existing loggroup?
6-according to the syntex we can add a logfile member in a log group by specifying the target group number or by giving the name and locations of existing
member(s) in the target group ,but i don't know how can i do this ,(loggroup1 is the name of a member of target group)
if i want to give this
alter database add logfile member 'e:oracleabc.log' to 'e:oracleloggroup1.log';
it always give me an error why?
regards.
shaheena.
Re: urgent pl........ [message #74817 is a reply to message #74815] Sat, 14 September 2002 05:09 Go to previous messageGo to next message
Murali Vallath
Messages: 1
Registered: September 2002
Junior Member
YOu should find answers to all the above questions in the Oracle documentation. Please read the documentation, its got a tone of information.
Re: urgent pl........ [message #74823 is a reply to message #74815] Tue, 05 November 2002 05:06 Go to previous messageGo to next message
siddhu
Messages: 3
Registered: November 2002
Junior Member
shaheena as for rest as murli pointed out oracle 9i docs are teh best bet but as per last question try this :
alter database add logfile member 'e:oracleabc.log' to group 1;

Hope it works .
Re: urgent pl. [message #74911 is a reply to message #74815] Wed, 25 August 2004 08:55 Go to previous message
Vaag
Messages: 9
Registered: August 2004
Junior Member
Hi Shaheena

1-what ia the default size of an oracle block(in 9i)?
Ans. 2048(default)

2-how many tablespaces we can create in a database(in 9i)?
Ans. Any number (but will b restricted by the max no. of datafiles U can have !)

3-how many datafiles are allowed in each tablespace?
Ans.Any Number
4-maximum datafiles allowed in the database?
Ans. Described by MAXDATAFILES parameter in Create database statement informtion of which is stored in control file. However the value is OS dependent which is limited by theoretical values of MAXDATAFILES.
5-how can we add a diffrent size logfile member in an already existing loggroup?
Ans. alter database add logfile group group 1 <filename> size nm.
6-according to the syntex we can add a logfile member in a log group by specifying the target group number or by giving the name and locations of existing
member(s) in the target group ,but i don't know how can i do this ,(loggroup1 is the name of a member of target group)
if i want to give this
alter database add logfile member 'e:oracleabc.log' to 'e:oracleloggroup1.log';
it always give me an error why?

Ans. you have to specify all the target group members in Braces
that can b done this way if there are 2 members

Alter database add logfile member 'e:oracleabc.log to
('member 1 ' , ' member 2' )

Hope this clears and I am not late.
Previous Topic: how to intstall oracle 9201 on hp_ux 11i
Next Topic: desparately seeking p3095277_9204_TRU64.zip
Goto Forum:
  


Current Time: Sun Dec 05 19:51:55 CST 2021