|
-
1.Should i need to add SGA_MAX_SIZE in pfile or its not required?
2. I'm unable to configure the value of large_pool_size dynamically. The system is getting altered but the changes are not getting stored while executing the statement SQL> show parameter large_pool_size i'm able to see the old value only. I started the DB using spfile.
3. create tablespace market
datafile '/opt/oracle/oradata/ARM/datafile1.dbf' size 1000M
extent management dictionary
default storage (INITIAL 100k NEXT 200k MINEXTENTS 2 MAXEXTENTS 60
PCTINCREASE 50);
While executing the above statement.. i'm getting the error 'cannot create dictionary managed tablespace'.
What could be the reason behind.?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|