329 reputation
15
bio website
location
age
visits member for 2 years, 7 months
seen Sep 18 at 14:41

Jun
12
comment use of synonyms in oracle
Overview of synonyms
Apr
10
answered Does hard-coding schema names in procedure calls for Oracle jobs have any performance impact?
Mar
13
comment Exception in SQL client but not in stored procedure
You don't get the exception or the output?
Sep
6
comment What is the meaning of “select * from relational(owner.table)”?
Found this, might help: forums.oracle.com/thread/1042943?start=0&tstart=0
Mar
23
awarded  Yearling
Jan
30
comment SYSAUX tablespace is 98%
this thread: dba.stackexchange.com/questions/15790/reduce-size-of-sysaux might be of some use
Aug
10
comment Oracle DBCA utility: “Listener is not up or database service is not registered with it”
what does your SID_LIST_LISTENER section look like?
Aug
9
answered Simple Search on 13 Terabyte Oracle Database to return relevant rows (.net app? Java?)
Jun
29
comment What are the edges of typical (or specific) paid databases like oracle of mysql compared to the free oness?
@Jim Thio, afaik, yes - if they use it for commercial purposes.
Jun
29
awarded  Commentator
Jun
29
comment What are the edges of typical (or specific) paid databases like oracle of mysql compared to the free oness?
Very nice explanation. I also wanted to compare those services to a bank.
Jun
29
comment What are the edges of typical (or specific) paid databases like oracle of mysql compared to the free oness?
docs.oracle.com/cd/E12151_01/doc.150/e12155/…
Jun
29
awarded  Critic
Jun
24
comment Which database?
There are too many factors that influence this kind of decision. Size of data is just one of them (and it would be more simple to list systems, which are not suitable for your needs). If there is no one esle in your company, who would be able to answer or give advice, the best you can do, is hire someone.
Jun
21
comment Optimization of an Oracle query
Try to run this on the remote database: EXPLAIN PLAN FOR Select * from Viewname where columnname='somevalue'; SELECT * FROM TABLE(DBMS_XPLAN.display); This will provide the explain plan mentioned by @Ben. Most probably the remote view is not optimal.
Jun
21
comment Optimization of an Oracle query
Is there a suitable index built on the remote table?
Jun
20
answered In Oracle how do you move a Schema to a different Tablespace?
Jun
12
answered Can a RDBMS connect to a remote server, execute a select query and copy them into a local table just with SQL commands?
May
29
answered Move data from one oracle db to another db using toad
May
22
comment How can I mimic functionality of SQL Server `TYPE` in Oracle?
You have answered the question yourself. The only way is to use object types.