Reputation
1,745
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
1 7 16
Newest
 Nice Answer
Impact
~442k people reached

Jan
6
comment Oracle partition by interval using persian calendar
@AmirPashazadeh - with a local index on xdate the plan still has PARTITION RANGE ALL; but the index would mean it's only actually retrieving data from one partition, since there is no table scan. With a lot of data though the index might not help much, and could slow things down, or be ignored; depends on the distribution. Adding the virtual column to the query is still the only way to help in this case I think.
Jan
6
comment Oracle partition by interval using persian calendar
@AmirPashazadeh - you could probably schedule the partition creation; but again only on Gregorian-monthly intervals...
Jan
6
revised Oracle partition by interval using persian calendar
Added execution plan note
Jan
6
revised Oracle partition by interval using persian calendar
More useful query
Jan
6
revised Oracle partition by interval using persian calendar
Adjusted the partition slightly, so 2013-03-20 ends P0 and appears in the final output.
Jan
6
answered Oracle partition by interval using persian calendar
Jan
6
comment Oracle partition by interval using persian calendar
Intervals are sensitive to NLS_CALENDAR (note 227334.1), but for table/partition definitions I guess it would have to be the database setting - the session level doesn't apply, and you can't override it in the interval itself. Assuming the DB parameter is Gregorian, it doesn't look like you can do this with intervals, and will have to manually define all the partitions? Another approach, I guess, would be to add a virtual column with a numeric representation of the month and partition on that?
Jan
6
comment Oracle partition by interval using persian calendar
Well, it's a month, not 30 days; but the point is that it's always using the Gregorian equivalent of the Persian date in the P0 partition to calculate the intervals for future partitions. So the automatic interval partitions don't align with the Persian calendar.
Jan
2
comment How to rollback last executed sql script fired as sysdba
@user3154598 - Second David's comment about being extremely careful about what you drop or change when trying to undo this; you don't want to end up in this situation by dropping something crucial, and pretty much everything owned by SYS is crucial. If you are not the DBA I suggest you get advice and sign-off from them before doing anything else.
Jan
2
answered web interface port for oracle 11g
Jan
2
comment web interface port for oracle 11g
Is the first dbcontrol instance still port 1158 by default? I can't remember how to check that off-hand... apart from stopping and starting it from the command line, which I think displays the URL.
Dec
27
comment why archived log size is small but fast recovery area still has a lot free space
How much space do you have in the filesystem(s) where your online redo logs live? It's complaining about where it wants to restore the file, not where it's archived.
Dec
17
comment Oracle installation fails due to ORA-00443
Is there an alert log, or any trace files for the failing processes?
Nov
18
awarded  Necromancer
Oct
12
comment “sqlplus as sysdba” startup error
How much memory is already allocated to the other three instances? How much is free? And what are the memory settings for the instance you're trying to start?
Oct
3
comment How do I debug an Oracle Linux Diskspace Issue?
OK, you don't have a /oradata partition, so it's trying to put it under /, which only has 2.6G free. You can check which partition you're working with and it's size with df -h /oradata/orcl/pdborcl. You could create the file somewhere under /home, or increase the size of /, or add a new partition.
Oct
3
comment How do I debug an Oracle Linux Diskspace Issue?
Where are you trying to create the file? Only /home has enough space? It might be helpful to show the exact command you're issuing and the error you get. (The Oracle tag is for database questions, not for other Oralce products; this is the wrong site for this question anyway).
Sep
24
awarded  Nice Answer
Sep
18
answered Is Oracle free to download?
Jul
30
comment ORA-03113: end-of-file on communication channel Can not connect
Is your D: drive mounted? Does the directory path to the online log files exist? Do the online log files exist?