Reputation
1,830
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
1 8 17
Newest
 Yearling
Impact
~643k people reached

Jan
13
comment Result on execution of any SQL is number 2
Also see Running SQL*Plus Commands, and more specifically Ending a SQL Command
Dec
21
comment create incremental number in oracle sql query
Why all the casting between strings and numbers? Not entirely sure what this adds to the existing answers as it isn't something the OP seemed to be looking for.
Nov
20
comment Creating pluggable database using dbca
Isn't this what you asked earlier, and got an answer to?
Nov
13
comment Why a oracle database needs a minimum of two on-line Redo Log Groups for normal database operation?
Sees the docs. So one is always available for writing while the other is being archived (or checkpointed in NOARCHIVELOG mode).
Nov
5
comment Can't create a Database on Oracle 11g
You gave full permissions to which user - your own account, or the one that Oracle is running under? Seems like an odd location for the ADR base anyway; why not somewhere under \Oracle?
Oct
21
comment Where is Oracle home user being stored
Did the things you already read include this and this?
Sep
10
comment Getting an error “ORA-00093: pga_aggregate_target must be between 10M and 4096G-1” on Oracle DB startup
Manually editing an spfile doesn't seem like a great idea; changing the values with alter commands, or creating a pfile from the spfile, editing that, and starting up from that pfile sound safer. Curious how you got the invalid value there in the first place though.
Sep
9
comment Remote connection issue from windows machine
Are you trying to telnet to the default port (23), or the listener port (1522)? What about tnsping, if you have that on machine B? What error do you get from SQL Developer? If your database is actually up, what is its local_listener parameter set to?
Aug
5
comment Oracle Temp Table Space - Alias clean up ORA-01119
Your edit is making things even less clear - what did you really run? What temporary file name was allocated by the CREATE TEMPORARY TABLESPACE TEMPRM_TEMP statement?
Aug
5
comment Oracle Temp Table Space - Alias clean up ORA-01119
You can see you're using two file names, right? Some other temporary TS is using, or has used, TEMPRM_TEMPFILE_1.dbf. Maybe you tried to create it before with a different TS name? What does dba_temp_files show? Or you created and dropped it with that name previously, but without including datafiles?
May
27
comment Why is there a difference in CSV Export Results of Oracle SQL Developer and SQL Plus Spool
Because they are different commands? You can spool from SQL Developer, which would be much more similar. What exactly is different between the outputs? Just saying it is very different isn't very helpful. You haven't shown the query you're running, either, which might be relevant.
Jan
24
comment Oracle StartUp Error
@ParveshSoni - then it might be best to delete this question, since it is off-topic for this site and is already asked on DBA. Thanks.
Jan
10
comment Help with Joins - Cartesian Product
This was cross-posted to SO and code review, the latter also migrated to SO; as there are already two versions not sure migrating this too would be helpful.
Oct
27
comment Unable to mount database: error reading control file
Trying things like replacing the files from your copies could make things worse. Do you have a recent control file backup (e.g. from backup controlfile to trace)? Is there a problem with the E: disk - have you verified the media itself?
Sep
21
comment ora-12705 cannot access NLS data files or invalid environment specified
Have you got the rest of your environment variables set properly, e.g. ORACLE_HOME?
Aug
1
comment How to use sqlplus to connect to an Oracle Database located on another host without modifying my own tnsnames.ora
@GlennLong - but in your version, database is still a TNS alias, which has to exist in the tnsnames.ora, so it's the same as Louis was trying to avoid?
Jul
31
comment How to create an oracle dump(.dmp) file using Toad?
@Oliver - Which error - 'does not currently know of service'? Did you change the tnsnames.ora to have SID = asdb?
Jul
31
comment How to create an oracle dump(.dmp) file using Toad?
No, I'd already said to create it in a different directory. Example added.
Jul
31
comment How to create an oracle dump(.dmp) file using Toad?
OK, so what is the service name? Can you see it from Toad, e.g. select value from v$parameter where name = 'service_names'? If you don't have privs to do that you'd need to ask your DBA. Or use your own tnsnames.ora file, specifying the SID instead.
Jul
31
comment How to create an oracle dump(.dmp) file using Toad?
That's the same service name you proposed for the tnsnames.ora entry. So it is actually the SID? How do you connect through Toad, with a device name or a SID? Do you know the actual service name of the database?