Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: carriage return in datafile name

Re: carriage return in datafile name

From: Sanjay Mathew <alsm1_at_micro.lucent.com>
Date: 1998/03/30
Message-ID: <351FEB91.15ADDD8D@micro.lucent.com>#1/1

I had this problem before.
What i did when it was getting unmanageble was, export all the objects in the file.
Drop the tablespace.
Recreate a blank tablespace
Reimport the objects.

I dont know if there is a better way.

Cheers
Sanjay mathew

elufker_at_swcp.com wrote:

> Hi All:
>
> Has anyone ever had a datafile with a carriage return as part of the name. I
> am having a helck of a time dropping this file. I am using Oracle v7.3.3.0
> running on a solaris 2.5.1 platform. Any hints on how to handle this. I can't
> get it offline or anything.
>
> thanks
> eddie lufker
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading
Received on Mon Mar 30 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US