Nov
14
awarded  Yearling
Aug
6
awarded  Notable Question
Jun
28
awarded  Notable Question
Jun
21
awarded  Famous Question
Jun
10
awarded  Popular Question
Apr
8
comment Importing schema to new or different tablespace
I'm working on something similar but it's a whole DB migration using expdp/impdp because I want our QA env to match production. If I use remap_tablespace it would remap every schema into another single tablespace, however I think I can run the impdp command once per schema and using remap_tablespace. This should achieve the job.
2018
Nov
16
accepted In a database trigger on event create - How do I reference the created object?
Nov
16
comment In a database trigger on event create - How do I reference the created object?
Thank you so much for that. Would you happen to know where the documentation for that is? I've spent a lot of time in the create trigger doc but it looks like it's missing a lot even with the 3 examples they have.
Nov
15
asked In a database trigger on event create - How do I reference the created object?
Oct
2
comment du of directories in a diskgroup in Oracle ASM
That is brilliant. Have my upvote.
Sep
17
awarded  Popular Question
Aug
2
awarded  Nice Question
May
25
awarded  Popular Question
May
3
awarded  Good Question
Mar
29
awarded  Yearling
Jan
24
comment Does an IOT guarantee order in a select?
If the table is big your order by statement may require more than 200MB which is the pga allocated to your session. Then it spills in temp TBS and slows down your query tremendously. one way to work around that could be to paralellize the query and get 200MB per session. You can alter the session to increase your PGA to a max of 2GB I believe.
2017
Aug
31
comment Instance and database (Oracle vs SQL Server)
@Sepster You make some good points but then it starts to look like a SQL Server specific conversation rather than an Oracle / SQL Server comparison. I tried to keep it simple while staying clear.
Jul
28
awarded  Popular Question
Jul
20
revised Instance and database (Oracle vs SQL Server)
grammar
May
23
awarded  Nice Answer