Reputation
14,739
Top tag
Next privilege 15,000 Rep.
Protect questions
Badges
1 27 40
Newest
 Yearling
Impact
~930k people reached

Sep
22
comment Need to clean up my Oracle database
I'm not sure that I understand what "By clean up, I mean the metadata of the tables" means. Perhaps you mean that you want to retain the metadata but remove all the data? From every table? Or just some tables (it seems likely that you'd need some tables to remain populated). I'm not sure why you would test on a production database. But presumably you can just do a fresh install of your application which will, presumably, install whatever lookup data you need.
Sep
18
comment Asking SQL schema by FOIA
When you say "schema", are you talking about the data model (i.e. just the DDL required to create the tables)? Or including the data as well? Either one is likely to be problematic from a security standpoint but the data is obviously a bigger risk.
Sep
16
comment is there a way to connect to mysql using oracle sqlplus instant client
The functionality might have existed some time back in the 9.x days (though ODBC on linux adds some extra complexity). That version of Oracle has been desupported for a long time so it's not going to be publicly available. You'd need to log a support ticket with Oracle (which assumes you have an active support contract). And it almost certainly won't be supported on any vaguely recent version of Linux. You'd have to be installing a version of Linux from back when 9i was supported which is probably roughly a decade ago.
Sep
16
comment Hash values vs. column values in an incremental load
This sort of thing tends to be very scenario specific so the only real answer is likely to be to benchmark both approaches in your application. 50 integer columns will almost certainly behave differently than 50 text columns with thousands of bytes each.
Sep
16
comment is there a way to connect to mysql using oracle sqlplus instant client
Why does your friend want to use Oracle's command-line utility to connect to a MySQL database? I have to believe that your friend really wants to use SQL*Plus to connect to an Oracle database and/or the MySQL client utilities to connect to a MySQL database.
Sep
16
comment is there a way to connect to mysql using oracle sqlplus instant client
Is it possible? Maybe. Why would you want to? Ancient versions of SQL*Plus had the ability to use generic ODBC DSNs to connect to non-Oracle databases. That was a horrible thing to do and basically no one ever did it. If memory serves, they removed the functionality at some point because it was such a poor idea. MySQL has its own command line utilities that work very well with MySQL. Why wouldn't you want to use those?
Sep
16
comment What privileges are needed to run EXPLAIN PLAN FOR CREATE INDEX?
You might also see if you have privileges on the dbms_space.create_index_cost function which estimates the size of an index docs.oracle.com/cd/B19306_01/appdev.102/b14258/…
Sep
16
comment What privileges are needed to run EXPLAIN PLAN FOR CREATE INDEX?
Does your user have privileges to create an index on the someone.sometable table? Is that a table in a different schema or in your schema?
Sep
14
comment Oracle how do i see who connected to my database
If you have enabled logging at the listener, and assuming the listener was used to establish the connection, it will write out a file of every connection attempt. But that is generally something that you'd need to enable not something that would be done by default. docs.oracle.com/cd/E11882_01/network.112/e41945/…
Sep
14
comment Oracle how do i see who connected to my database
Assuming these people are no longer connected, your options may be limited. Do you enable logging in your listener? Do you audit logins? Are you licensed to use the AWR? Is Statspack installed and running? How accurate do the results need to be? Do you need a completely accurate count or can you live with an approximate accounting that relies on various assumptions? Are you looking for the Oracle user that was logged in or are you trying to get information about the operating system user, client machine, etc?
Sep
14
awarded  Informed
Sep
9
comment Restore .dmp file into csv
Your basic options, assuming this is actually a file generated by the Oracle export utility (classic or Data Pump) would be to 1) find a third party tool, 2) install Oracle and import it there, or 3) ask the customer to give you a CSV file.
Sep
9
comment Restore .dmp file into csv
Unlikely. If that is a file generated by either the classic or Data Pump version of the Oracle export utility, it's a proprietary binary file format. There may be third party tools that could read the .dmp file and produce a .csv file. But then you're evaluating tools, buying a tool, learning the tool, etc. On a one-off basis, it may be just as easy to grab the express edition of Oracle, restore it, and then generate whatever you want. Or to ask the customer to generate an actual CSV file.
Sep
9
comment VARCHAR2 should perhaps be DT_WSTR when working with SSIS against a Oracle Database?
Be aware that if you have existing scripts with VARCHAR2(255), you can do an ALTER SESSION to set NLS_LENGTH_SEMANTICS to CHAR and then run them to get character rather than byte semantics. That's easier than manually editing bunches of scripts.
Sep
9
comment Oracle NVARCHAR2(4000) with AL32UTF8 possible?
@PatrickSzalapski If you need an NVARCHAR2 column (which seems odd but I've not played with SSIS and Oracle and Unicode), then you'd use the NLS_NCHAR_CHARACTERSET. Depending on the Oracle version, you may be able to set that to AL32UTF8 (but that would generally not be recommended). Assuming your NLS_NCHAR_CHARACTERSET is AL16UTF16, then you'd use the UTF-16 encoding for NVARCHAR2 columns. Assuming you are not using 12.1 or later with 32k columns enabled, then you're limited to 4000 bytes or 2000 UTF-16 characters.
Sep
9
answered Oracle NVARCHAR2(4000) with AL32UTF8 possible?
Sep
9
comment Getting the “ORA-00911” error when I am trying to insert more than 1 row
@miracle173 - I'm presenting two options. The first (recommended) approach is to put everything in an anonymous PL/SQL block. The second is to leave it a series of SQL statements and add a separator. As I say in my answer, whether a separator is needed will depend on the front-end tool. Since the original poster didn't specify that, given the error, I inferred that the tool (or the command being used in the tool) required the separator.
Sep
9
comment Will a WHERE query do checks on simpler comparisons (i.e. bit) before running more arduous comparisons (i.e. varchar)?
As with anything, it depends. What indexes are available? How selective is the predicate? Are there other predicates in the query that you are trying to avoid evaluating? Or just these two?
Sep
8
comment Oracle 11g bug ? not returning the record until I triggered index to invisible and then to visible
If what you are describing is correct, you encountered a bug. You'd want to contact Oracle Support for assistance dealing with bugs. It's entirely possible that there is a patch they can send you that would fix the issue. Or they can identify the bug and tell you exactly what causes it and the workarounds.
Sep
7
comment How to create a function(table_name) that return a collection in Oracle?
Why? Why return a collection rather than a simple cursor? Why does it need to be dynamic? That combination is almost never a good idea. You can use the Data Cartridge functionality to do this oracle-developer.net/display.php?id=422 However that is insanely complicated code. It is very, very likely that there is a better solution to whatever problem you actually have.