All Questions

Tagged with
Filter by
Sorted by
Tagged with
1
vote
1answer
325 views

How to refresh Oracle data dictionary to remove deleted tablespace and datafiles?

Long story short we have a server with two Oracle instances running on it: ora1 and ora2. Somebody defined an undo tablespace for ora2 and provided the same datafile of the undo tablespace datafile of ...
1
vote
1answer
1k views

How to delete tablespace and table after delete datafiles?

I deleted datafiles with asmcmd. I need to delete tablespace and tables on this tablespace. I tried: drop tablespace tablespace_name including contains cascade constraints getting error: ORA-14405: ...
0
votes
1answer
9k views

ORA-01122: database file 5 failed verification check

Oracle version: 11g r2 OS: win server 2008 SQL> alter database open; alter database open * ERROR at line 1: ORA-01122: database file 5 failed verification check ORA-01110: data ...
0
votes
2answers
2k views

Drop datafile without dropping a tablespace in Oracle 11g

I was trying to take backup of database in Oracle 11g by using RMAN $ rman target / Recovery Manager: Release 11.2.0.1.0 - Production on Fri Sep 11 10:14:37 2015 Copyright (c) 1982, ...
0
votes
1answer
5k views

How to copy tablespace from one database to another database in Oracle 11g

How to copy tablespace and datafiles from one database to another database in Oracle 11g in same server ?
0
votes
1answer
32 views

Instant File Initialisation on Windows Oracle Server

I require to add additional datafiles to a SmallFile tablespace. The process took several minutes on my system for 1 datafile. Is it possible to allow Oracle the same capability as SQL Server using ...
4
votes
2answers
11k views

Shrinking the SYSTEM tablespace in Oracle

Our SYSTEM tablespace grew out of control because of the SYS.AUD$ table. We have truncated SYS.AUD$ but the datafile is still very big (~30G). Resize doesn't work because the file contains used data ...