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

Feb
8
awarded  Yearling
Jan
13
awarded  Critic
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
answered Remote connection issue from windows machine
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.
Mar
19
awarded  Nice Answer
Feb
8
awarded  Yearling
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
30
awarded  Explainer