Reputation
1,755
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
1 7 16
Newest
 Nice Answer
Impact
~521k people reached

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
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?
Jul
31
answered How to create an oracle dump(.dmp) file using Toad?
Jul
8
comment ORA : 12519 No appropriate Service Handler
You don't need both SID and SERVICE_NAME. This ought to work with just the service name.
Jul
7
comment ORA : 12519 No appropriate Service Handler
Cross-posted on SO; that might be migrated here soon though.
Jun
25
comment Why does second instance of database not open?
Did you copy all the .dbf and .log files from test to orcl; and if so was test up at the time? What does your new init.ora look like? It might be useful to show the steps you went through in the order you did them.
Jun
11
comment Inner Join Performance
Please don't post the same question on multiple sites. There's a FAQ about this on meta.