-
I made a really stupid mistake and now I can't figure out how to fix it.
I created a datafile wiith a space after the .dbf
alter tablespace data_01
add datafile
'/u02/oradata/ads02/df_ads02_data_01_3.dbf ' size 1024M;
Now there is some sort of special charecter at the end of .dbf
I copied the file to another file
cp df_ads02_data_01_3* df_test.dbf
That worked
Then when I tried the alter I get the fillowing error
I also tried it with a wildcard at the here also ie df_ads02_data_01_3%
1 alter tablespace data_01
2 rename datafile '/u02/oradata/ads02/df_ads02_data_01_3.dbf'
3* to '/u02/oradata/ads02/df_test.dbf'
SQL> /
alter tablespace data_01
*
ERROR at line 1:
ORA-01525: error in renaming data files
ORA-01522: file '/u02/oradata/ads02/df_ads02_data_01_3.dbf' to be renamed does
not exist
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|