2,331 reputation
518
bio website
location Austria
age 57
visits member for 3 years, 4 months
seen 28 mins ago

13h
reviewed Approve suggested edit on How do you mysqldump specific table(s)?
13h
reviewed Approve suggested edit on Oracle 11.2 Configuring authentication
21h
reviewed Edit suggested edit on Correlated query Issue
21h
revised Correlated query Issue
Formatted the question
21h
reviewed Approve suggested edit on SQL Server Backup Job failed multiple times
1d
awarded  Revival
1d
reviewed Approve suggested edit on Database design: 4 types of users but have different functionality , separate or one table?
1d
reviewed Approve suggested edit on Query optimizer recommends adding index instead of using existing index
2d
reviewed Approve suggested edit on SQL server transaction log recovery
2d
reviewed Approve suggested edit on Import csv data from localhost emacs SQLi error MySQL
2d
comment Unable to mount database: error reading control file
Did you already solve your problem?
Oct
27
answered Unable to mount database: error reading control file
Oct
27
comment Don't know how to transform variable entity into relational table
+1 What is confusing me is the lack of primary keys in the table diagrams. Especially in the "classTableInheritance" I cannot see that all these table are connected by the same primary key.
Oct
27
comment Don't know how to transform variable entity into relational table
The transformation of EER diagrams to tables can be found in this paper from 1986 of T.J.Teorey, D.Yang,J.P.Fry: A Logical Design Methodology for Relational Databases Using the Extended Entity-Relationship Model. It is straightforward and one of my favorite papers.
Oct
27
reviewed Approve suggested edit on inserting information into database tables created using wamp server
Oct
27
comment Oracle PLSQL code recovery
-1 He has to recover because he cannot connect to the database?
Oct
27
comment ORA-01033 “ORACLE initialization or shutdown in progress” caused by ORA-10567 “REDO is inconsistent with data block”
-1 except "contact Oracle support" all this advice is nonsense
Oct
27
comment ORA-01033 “ORACLE initialization or shutdown in progress” caused by ORA-10567 “REDO is inconsistent with data block”
-1 because this is nonsense. The undo tablespace holds information necessary to undo the open transactions after the archives/redos are applied.To change the undo tablespace the database must be open and the tablespace must not be damaged.
Oct
20
answered Configuring sqlnet.ora and tnsnames.ora on the client side
Oct
20
comment Configuring sqlnet.ora and tnsnames.ora on the client side
The difference of oracle instant client and the traditionally installed oracle client is in how they are installed. The Oracle universal installer maintains e registry which the instan client does not have. but the same softwre components are the same independen of the method you use to install. If you use the jdbc oci driver then you use a layer above the you use the layer above oracle oci client (which is used the oracle client libraries that use