OraFAQ Forum: RAC & Failsafe » urgent pl........

Home » Server Options » RAC & Failsafe » urgent pl........

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

urgent pl........ [message #74815]

Sat, 27 July 2002 04:31

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.

Report message to a moderator

Re: urgent pl........ [message #74817 is a reply to message #74815]

Sat, 14 September 2002 05:09

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.

Report message to a moderator

Re: urgent pl........ [message #74823 is a reply to message #74815]

Tue, 05 November 2002 05:06

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 .

Report message to a moderator

Re: urgent pl. [message #74911 is a reply to message #74815]

Wed, 25 August 2004 08:55

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.

Report message to a moderator

Previous Topic:	how to intstall oracle 9201 on hp_ux 11i
Next Topic:	desparately seeking p3095277_9204_TRU64.zip

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jun 05 07:05:30 CDT 2025