Oradata folder is not created while Java Systemcopy!!!

[Former Member]

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

[former_member182657 · Accepted solution]

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,

[Former Member · Accepted solution]

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

[former_member182657 · Accepted solution]

Hi,

Try below SQL command to locate the location of temp files in your system.

SQL > select TABLESPACE_NAME, BYTES_USED, BYTES_FREE from V$TEMP_SPACE_HEADER;

Hope this will help you.

Regards,