| 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.
|
|
|
|
|
|
| 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 .
|
|
|
|
| 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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
