Reputation
15,221
Top tag
Next privilege 20,000 Rep.
Access 'trusted user' tools
Badges
1 27 53
Newest
 Reviewer
Impact
~1.0m people reached

1d
comment Can I connect to remote oracle database without local oracle database installed?
Download the instant client and the instant client sqlplus option.
1d
comment Can I connect to remote oracle database without local oracle database installed?
Exactly. So has $ORACLE_HOME/bin been added to your $PATH ?
1d
comment Can I connect to remote oracle database without local oracle database installed?
"Command not found in my Solaris shell" -- nothing to do with Unix? Tell me how to find sqlplus then? If you don't know, it has everything to do with Unix.
1d
comment How to install Oracle DB 12c on Solaris 11.2?
The documentation is very clear. It has all of the commands you need to execute.
1d
comment Can I connect to remote oracle database without local oracle database installed?
You don't have enough Unix experience. Setting the PATH is trivial. Ask on a different site to do that
1d
comment How to install Oracle DB 12c on Solaris 11.2?
It explains in simple English. Read the documentation. Help is available for £50 an hour for personal tuition if FREE isn't enough
Apr
15
comment dbms_datapump API exclude statistics during import
Next time I'll write "You need to use", instead of "try". :)
Apr
15
comment dbms_datapump API exclude statistics during import
Like I don't know how to use the site, Colin?
Apr
15
comment Macro to search list JDE ERP
Don't think you're going to get much JD Edwards help here, I'm afraid.
Apr
13
comment Query Optimization with Indexes
Which RDBMS? You need to expand on your question significantly
Apr
12
comment How to downgrade Oracle Database from 11gr2 to 10g?
Why do this? 10.2 is no longer supported.
Apr
6
comment From keyword not found?
SELECT "REGO", "MAKE" TO_CHAR (SYSDATE, 'DD/MM/YY')NOW; -- Not valid SQL. Too simple a question for this site, I'm afraid
Apr
6
comment GRANT permission to access to respective creator
It is that. You don't understand the answer you have accepted, which is a row based security implementation
Apr
5
comment GRANT permission to access to respective creator
So you're looking to do row based security?
Apr
4
comment Tmpfs for mysql tmp dir questions
768M is nothing these days. Just pay more for your virtual machine and up it significantly.
Apr
4
comment IS-A relation when defining tables
Is an artist a singer, a band, or can it be both? That's your problem. I'd say a singer is a type of artist, and a band is made up of artists, so maybe you just need bands and artists, with an artist type of singer?
Apr
4
comment Rman append archivelog to backup
backup archivelog all
Mar
31
comment Oracle: built in SQL pretty-print?
If the given SQL will correctly parse ok in your current database, you might be able to use DBMS_SQL.PARSE to get it into the shared pool without executing it, then use DBMS_METADATA to pretty print it. Obviously won't work if the statement won't parse in the current session due to missing objects.
Mar
30
comment Slow running Oracle query caused by unnecessary full table scan
Are stats up to data on both tables? Any histograms? What's the cardinality of the data?
Mar
30
comment Oracle 11.2 restore DB to a specific point
How much data is going to change? This is the most important thing, as it affects the decision to use flashback