Tag Info

Hot answers tagged


Use this on Windows (three nested double quotes): exp system/password_for_system@dev file=c:\fooadmin.dmp full=yes imp """sys/password12345@dev as sysdba""" FROMUSER=FOOADMIN TOUSER=FOOADMIN file=c:\fooadmin.dmp In general imp would work as intended with sys account, it is just not recommended. But exp with sys account could possibly produce inconsistent ...


You can think of aggregate queries as two parts: columns that are included in GROUP BY, and columns that are included in aggregate functions, like SUM(), MAX(), COUNT(), etc. To put things very simply, if the column is in the SELECT clause, it has to either appear in the GROUP BY or inside an aggregate function. In your case, you're probably looking for ...

Only top voted, non community-wiki answers of a minimum length are eligible