Re: Re: Dropping Tablespaces with missing datafiles
Quote:
Originally posted by abhaysk
This sounds almost impossible.....
When the tablespace is online it would have obiviously locked all its datafiles....& when file is locked at OS level you just cant delete/rename/move the file.
I wonder how on earth ( may it be any OS ) lets you delete file when locked?
Can any one tell how this can be done...Tried to simulate the problem but it seems almost impossible.
Abhay.
U R on windows OS I guess :p :p :p :D :D :D
Re: Re: Re: Dropping Tablespaces with missing datafiles
Quote:
Originally posted by nagarjuna
U R on windows OS I guess :p :p :p :D :D :D
wass big deal...and y r u so amused?
making all such faces?????
i dont see any point....
Abhay.
Re: Re: Re: Re: Dropping Tablespaces with missing datafiles
Quote:
Originally posted by abhaysk
wass big deal...and y r u so amused?
making all such faces?????
i dont see any point....
Abhay.
:p :p :p :D :D :D
Quote:
Originally posted by abhaysk
This sounds almost impossible.....
When the tablespace is online it would have obiviously locked all its datafiles....& when file is locked at OS level you just cant delete/rename/move the file.
I wonder how on earth ( may it be any OS ) lets you delete file when locked
:p :p :p :D :D :D
If you dont know, learn it.. Dont make sentences. Good DBAs should have patience. You dont have a bit of it. In UNIX, Oracle does not lock the files at OS level.
Re: Re: Re: Re: Re: Dropping Tablespaces with missing datafiles
Quote:
Originally posted by nagarjuna
:p :p :p :D :D :D
:p :p :p :D :D :D
If you dont know, learn it.. Dont make sentences. Good DBAs should have patience. You dont have a bit of it. In UNIX, Oracle does not lock the files at OS level.
i do have patientence.....
now unix dosent lock the file even though its in use??
thats rediculous....i dont have knowledge in unix but wass the point in not locking a file even if it is in use....
If this is the case then I would better reley on Windows...
Abhay.