| very urgent.......... [message #70817] |
Sat, 27 July 2002 04:18  |
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: very urgent.......... [message #70828 is a reply to message #70817] |
Mon, 29 July 2002 02:21  |
sunil bhola
Messages: 58
Registered: July 2002
|
Member |
|
|
1-what ia the default size of an oracle block(in 9i)?
Ans.) In oracle9i you can use upto 5 differenct block size, but the first block size that is buffer_block_cache is the default.
2-how many tablespaces we can create in a database(in 9i)?
Ans.) unlimited, but according to the hard disk size.
3-how many datafiles are allowed in each tablespace?
Ans.) umlimited( but on oracle 7 to 8) only 1024 datafile are there.
4-maximum datafiles allowed in the database?
Ans.) umlimited
5-how can we add a diffrent size logfile member in an already existing loggroup?
Ans.) by using REUSE option while creating logfile member.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
