Reputation
2,965
Top tag
Next privilege 3,000 Rep.
Cast close & reopen votes
Badges
8 20
Newest
 Necromancer
Impact
~304k people reached

8h
comment Speed up COUNT(*) when using an index
can you add the output of an explain of your query
9h
comment Speed up COUNT(*) when using an index
The query only reads 1/12th of the index to count all books of category 1? How should that work? When does it stop to read the index?
11h
comment How many passes of a table are done with UNION ALL?
that query does not make sense it you don't tell us what dbms your are using and what query you are posing.
15h
comment Three-sided many-to-many relationship design
What does to map a table with another table mean?
15h
revised Delete rows where matched value is twice as much
deleted 2 characters in body
1d
reviewed Approve Generating a sequence of values
1d
revised How to restore 11gR2 fullbackup to 12c database in rman
typo
1d
comment How to restore 11gR2 fullbackup to 12c database in rman
I removed the -1. Even if the restore to a different Oracle version is possible if it is combined in this situation that dos not make sense. Especially it is right that the rman does not the upgrade,
1d
reviewed Approve Running a complex query for every date in a range
1d
comment Oracle DB - DR corruption
Maybe there is a way only to restore the corrupt datablocks from the backup. That is an interesting topic that I will need in the future, too, because I am setting up a lo f dataguards now. But currently I have no time to investigate that.
1d
awarded  Necromancer
1d
comment Selecting records where date range is current year minus #years
You are looking for the mos efficient way? Which ways did you consider? How many rows/bytes do you want to delete/keep? What version of Oracle do you use?
1d
reviewed Approve Creating a trigger to update field in 1 table based on values in another table using data in multiple rows
1d
comment Why would I need a third table in a one-to-many relationship?
as @ypercube already mentioned, there are a lot of texts that state that in a one-to-many relationship both sides can be optional, e.g T.Teory, Database Modeling & Design, p.81f. Also in a one-to-one relationship one or two sides can be optional.
1d
comment Location of RMAN backup
How do you actually start your backup?
1d
revised Why would I need a third table in a one-to-many relationship?
added 205 characters in body
1d
comment Why would I need a third table in a one-to-many relationship?
I have already posted an answer and now read your comment (and picture here). You should add the picture to your post and not hide it in a comment. Then the statement of your professor will become clear.
1d
answered Why would I need a third table in a one-to-many relationship?
2d
reviewed Reject Database design - need someone to guide me
2d
comment Is dmp file suitable despite ORA-01555 'snapshop too old' warnings?
you use exp because exdp does not exist for 8.1.7. The 'consistent=y' parameter means that the "Export uses the SET TRANSACTION READ ONLY statement to ensure that the data seen by Export is consistent to a single point in time and does not change during the execution of the exp command.". So if you export some tables at a later point in time your data will not be conistent anymore. This may be a problem.