on 01-28-2015 6:57 AM
Hi Experts,
While doing System copy in as JAVA system getting error like ORA-01652: unable to extend temp segment by 128 in tablespace PSAPTEMP,
for this trying increase tablespace by using alter tablespace "PSAPTEMP add tempfile 'e:\oracle\app\oradata\zoom\temp02.dbf' size 1g autoextend on;"
but in Oracle folder path oradata folder is not cretaed.
Please let me know what could be the problem?
Oracle version:11.0.2.0
Warm regards,
Sayendra.M
9591654386
Hi,
but in Oracle folder path oradata folder is not cretaed.
Could you check the exact data file path on your OS and share the error message during the execution of command
alter tablespace "PSAPTEMP add tempfile 'e:\oracle\app\oradata\zoom\temp02.dbf' size 1g autoextend on;"
Try to check the location of other temp data files and modify the command according to your exact data file locations.
Regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Gaurav,
The command which i have shared that is only example,
As my knowldege ".dbf" files will store in oradata, but Oradata directory is not created.
In Oralce folder path the below folders were created
Checkpoints
diag
SID
product
Is there any command to check .dbf files???
Thanks in Advance.
Regards,
Sayendra.M
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.