Mailing List
Home
Forum Home
Oracle List - by freelists.org
Oracle on SUSE Linux - Runing Oracle on SUSE Linux
Oracle database error code ...
www.freelists.org
Subjects
• ORA 12540: TNS:internal limit restriction exceeded
• ORA 12838 please : Is possible to append two times to the same table befo
• ORA 12838 please : Is possible to append two times to the same table before
• ora 04031
• ora 12500 on windows
• ORA 32004: obsolete and/or deprecated parameter(s) specified
• ORA 01925: maximum of 30 enabled roles exceeded
• ORA 01925: maximum of 30 enabled roles exceeded
• ora 12500 on windows
• ORA 01650, one idea
• ORA 01650
• ORA 4030
• ORA 12838 please : Is possible to append two times to thesametable before do
• ORA 12838 please : Is possible to append two times to thesame table before d
• ORA 01536
• ORA 03113 end of file on communication channel
• ORA 32004: obsolete and/or deprecated parameter(s) specified
• ORA 00600:
• ORA 00020: maximum number of processes (%s) exceeded
• ORA 01925: maximum of 30 enabled roles exceeded
• ORA 3113 while creating a cluster database 9201 RAC on Linux with OCFS
• ora 12500 on windows
• ora 12500 on windows
• ora 12500 on windows
• ORA 01650, one idea
• ora 12500 on windows
• ora 12500 on windows
• ora 12500 on windows
• ORA 2000 Error Using DBMS STATS GATHER SCHEMA STATS
• ORA 01650, one idea
• ORA 01650, one idea
• ORA 01650, one idea
• ORA 01650
• ORA 01650
• Subject: ora 01031
• ORA 4030
• ORA 4030
• ORA 06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind
• Subject: Re: ORA 01722 invalid number
 
Subject: Lost an empty datafiloe with empty partitions, how to fix

Subject: Lost an empty datafiloe with empty partitions, how to fix

2007-10-03       - By Kline.Michael

 Back
I could easily recreate this tablespace, but I need to get rid of the
partition first.

I've done the offline drop, but it won't let go of the handle.

Any suggestions?



SQL> ALTER TABLE REPADMIN.T_INSTRU_BAL DROP PARTITION
T_INSTRU_BAL_200610
ALTER TABLE REPADMIN.T_INSTRU_BAL DROP PARTITION T_INSTRU_BAL_200610
Error at line 2
ORA-00376 (See http://ORA-00376.ora-code.com): file 76 cannot be read at this time
ORA-01110 (See http://ORA-01110.ora-code.com): data file 76: '/PFRPT_p011/oradata/PFRPT/ts_bal_m201.dbf'



Michael Kline


BlackBerry: 804.517.7443
 
 
 
LEGAL DISCLAIMER
The information transmitted is intended solely for the individual or entity to
which it is addressed and may contain confidential and/or privileged material.
Any review, retransmission, dissemination or other use of or taking action in
reliance upon this information by persons or entities other than the intended
recipient is prohibited. If you have received this email in error please
contact the sender and delete the material from any computer.
 
SunTrust and Seeing beyond money are federally registered service marks of
SunTrust Banks, Inc.
[ST:XCL]





<HTML xmlns:eXclaimer="http://www.exclaimer.co.uk">
<HEAD>
<META http-equiv="Content-Type" content="text/html; charset=UTF-16 (See http://UTF-16.ora-code.com)">
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=UTF-16 (See http://UTF-16.ora-code.com)">
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=ProgId content=Word.Document>
<meta name=Generator content="Microsoft Word 11">
<meta name=Originator content="Microsoft Word 11">
<link rel=File-List href="cid:filelist.xml@(protected)">
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PersonName"/>
<!--[if gte mso 9]><xml>
<o:OfficeDocumentSettings>
 <o:DoNotRelyOnCSS/>
</o:OfficeDocumentSettings>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:WordDocument>
 <w:DisplayBackgroundShape/>
 <w:SpellingState>Clean</w:SpellingState>
 <w:GrammarState>Clean</w:GrammarState>
 <w:DocumentKind>DocumentEmail</w:DocumentKind>
 <w:EnvelopeVis/>
 <w:PunctuationKerning/>
 <w:ValidateAgainstSchemas/>
 <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>
 <w:IgnoreMixedContent>false</w:IgnoreMixedContent>
 <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>
 <w:Compatibility>
  <w:BreakWrappedTables/>
  <w:SnapToGridInCell/>
  <w:WrapTextWithPunct/>
  <w:UseAsianBreakRules/>
  <w:DontGrowAutofit/>
 </w:Compatibility>
 <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>
</w:WordDocument>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:LatentStyles DefLockedState="false" LatentStyleCount="156">
</w:LatentStyles>
</xml><![endif]--><!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@(protected)
  {font-family:Courier;
  panose-1 (See http://ose-1.ora-code.com):2 7 4 9 2 2 5 2 4 4;
  mso-font-charset:0;
  mso-generic-font-family:modern;
  mso-font-format:other;
  mso-font-pitch:fixed;
  mso-font-signature:3 0 0 0 1 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
  {mso-style-parent:"";
  margin:0in;
  margin-bottom:.0001pt;
  mso-pagination:widow-orphan;
  font-size:12.0pt;
  font-family:"Times New Roman";
  mso-fareast-font-family:"Times New Roman";}
a:link, span.MsoHyperlink
  {color:blue;
  text-decoration:underline;
  text-underline:single;}
a:visited, span.MsoHyperlinkFollowed
  {color:purple;
  text-decoration:underline;
  text-underline:single;}
span.EmailStyle17
  {mso-style-type:personal-compose;
  mso-style-noshow:yes;
  mso-ansi-font-size:12.0pt;
  mso-bidi-font-size:12.0pt;
  font-family:"Courier New";
  mso-ascii-font-family:"Courier New";
  mso-hansi-font-family:"Courier New";
  color:windowtext;
  font-weight:normal;
  font-style:normal;
  text-decoration:none;
  text-underline:none;
  text-decoration:none;
  text-line-through:none;}
span.GramE
  {mso-style-name:"";
  mso-gram-e:yes;}
@(protected) Section1
  {size:8.5in 11.0in;
  margin:1.0in 1.25in 1.0in 1.25in;
  mso-header-margin:.5in;
  mso-footer-margin:.5in;
  mso-paper-source:0;}
div.Section1
  {page:Section1;}
-->
</style>
<!--[if gte mso 10]>
<style>
/* Style Definitions */
table.MsoNormalTable
  {mso-style-name:"Table Normal";
  mso-tstyle-rowband-size:0;
  mso-tstyle-colband-size:0;
  mso-style-noshow:yes;
  mso-style-parent:"";
  mso-padding-alt:0in 5.4pt 0in 5.4pt;
  mso-para-margin:0in;
  mso-para-margin-bottom:.0001pt;
  mso-pagination:widow-orphan;
  font-size:10.0pt;
  font-family:"Times New Roman";
  mso-ansi-language:#0400;
  mso-fareast-language:#0400;
  mso-bidi-language:#0400;}
</style>
<![endif]--><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
 <o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</HEAD><BODY lang=EN-US link=blue vlink=purple style='tab-interval:.5in'><DIV>
<FONT SIZE="+0">
<DIV>
<FONT FACE="Courier">
<DIV>
<FONT FACE="Courier">
<DIV>
<FONT FACE="Courier">
<DIV>
<FONT FACE="Times New Roman">

<div class=Section1>

<p class=MsoNormal style='mso-layout-grid-align:none;text-autospace:none'><font
size=2 color=black face=Courier><span style='font-size:10.0pt;font-family
:Courier;
mso-bidi-font-family:Courier;color:black;background:white;mso-highlight:white'>I
could easily recreate this tablespace, but I need to get rid of the partition
first.<o:p></o:p></span></font></p>

<p class=MsoNormal style='mso-layout-grid-align:none;text-autospace:none'><font
size=2 color=black face=Courier><span style='font-size:10.0pt;font-family
:Courier;
mso-bidi-font-family:Courier;color:black;background:white;mso-highlight:white'>
<o:p>&nbsp;</o:p></span></font></p>

<p class=MsoNormal style='mso-layout-grid-align:none;text-autospace:none'><font
size=2 color=black face=Courier><span style='font-size:10.0pt;font-family
:Courier;
mso-bidi-font-family:Courier;color:black;background:white;mso-highlight:white'
>I&#8217;ve
done the offline drop, but it won&#8217;t let go of the handle.<o:p></o:p><
/span></font></p>

<p class=MsoNormal style='mso-layout-grid-align:none;text-autospace:none'><font
size=2 color=black face=Courier><span style='font-size:10.0pt;font-family
:Courier;
mso-bidi-font-family:Courier;color:black;background:white;mso-highlight:white'>
<o:p>&nbsp;</o:p></span></font></p>

<p class=MsoNormal style='mso-layout-grid-align:none;text-autospace:none'><span
class=GramE><font size=2 color=black face=Courier><span style='font-size:10.0pt;
font-family:Courier;mso-bidi-font-family:Courier;color:black;background:white;
mso-highlight:white'>Any suggestions?</span></font></span><font size=2
color=black face=Courier><span style='font-size:10.0pt;font-family:Courier;
mso-bidi-font-family:Courier;color:black;background:white;mso-highlight:white'>
<o:p></o:p></span></font></p>

<p class=MsoNormal style='mso-layout-grid-align:none;text-autospace:none'><font
size=2 color=black face=Courier><span style='font-size:10.0pt;font-family
:Courier;
mso-bidi-font-family:Courier;color:black;background:white;mso-highlight:white'>
<o:p>&nbsp;</o:p></span></font></p>

<p class=MsoNormal style='mso-layout-grid-align:none;text-autospace:none'><font
size=2 color=black face=Courier><span style='font-size:10.0pt;font-family
:Courier;
mso-bidi-font-family:Courier;color:black;background:white;mso-highlight:white'>
<o:p>&nbsp;</o:p></span></font></p>

<p class=MsoNormal style='mso-layout-grid-align:none;text-autospace:none'><font
size=2 color=black face=Courier><span style='font-size:10.0pt;font-family
:Courier;
mso-bidi-font-family:Courier;color:black;background:white;mso-highlight:white'>
<o:p>&nbsp;</o:p></span></font></p>

<p class=MsoNormal style='mso-layout-grid-align:none;text-autospace:none'><font
size=2 color=black face=Courier><span style='font-size:10.0pt;font-family
:Courier;
mso-bidi-font-family:Courier;color:black;background:white;mso-highlight:white'
>SQL&gt;
ALTER TABLE REPADMIN.T_INSTRU_BAL DROP PARTITION T_INSTRU_BAL_200610<o:p></o:p>
</span></font></p>

<p class=MsoNormal style='mso-layout-grid-align:none;text-autospace:none'><font
size=2 color=black face=Courier><span style='font-size:10.0pt;font-family
:Courier;
mso-bidi-font-family:Courier;color:black;background:white;mso-highlight:white'
>ALTER
TABLE REPADMIN.T_INSTRU_BAL DROP PARTITION T_INSTRU_BAL_200610<o:p></o:p></span
></font></p>

<p class=MsoNormal style='mso-layout-grid-align:none;text-autospace:none'><font
size=2 color=black face=Courier><span style='font-size:10.0pt;font-family
:Courier;
mso-bidi-font-family:Courier;color:black;background:white;mso-highlight:white'
>Error
at line 2<o:p></o:p></span></font></p>

<p class=MsoNormal style='mso-layout-grid-align:none;text-autospace:none'><font
size=2 color=black face=Courier><span style='font-size:10.0pt;font-family
:Courier;
mso-bidi-font-family:Courier;color:black;background:white;mso-highlight:white'
>ORA-00376 (See http://ORA-00376.ora-code.com):
file 76 cannot be read at this time<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 color=black face=Courier><span
style='font-size:10.0pt;font-family:Courier;mso-bidi-font-family:Courier;
color:black;background:white;mso-highlight:white'>ORA-01110 (See http://ORA-01110.ora-code.com): data file 76:
'/PFRPT_p011/oradata/PFRPT/ts_bal_m201.dbf'</span></font><font size=2
color=black face=Courier><span style='font-size:10.0pt;font-family:Courier;
mso-bidi-font-family:Courier;color:black'><o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 color=black face=Courier><span
style='font-size:10.0pt;font-family:Courier;mso-bidi-font-family:Courier;
color:black'><o:p>&nbsp;</o:p></span></font></p>

<p class=MsoNormal><font size=3 face="Courier New"><span style='font-size:12
.0pt;
font-family:"Courier New";mso-bidi-font-family:"Times New Roman"'><o:p>&nbsp;<
/o:p></span></font></p>

<p class=MsoNormal><font size=3 face="Courier New"><span style='font-size:12
.0pt;
font-family:"Courier New";mso-bidi-font-family:"Times New Roman"'><o:p>&nbsp;<
/o:p></span></font></p>

<p class=MsoNormal><st1:PersonName w:st="on"><font size=2 face="Courier New">
<span
style='font-size:10.0pt;font-family:"Courier New";mso-no-proof:yes'>Michael
Kline</span></font></st1:PersonName><br style='mso-special-character:line
-break'>
<![if !supportLineBreakNewLine]><br style='mso-special-character:line-break'>
<![endif]><span style='mso-no-proof:yes'><o:p></o:p></span></p>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt;mso-no-proof:yes'>BlackBerry: 804.517.7443<br style='mso-special
-character:
line-break'>
<![if !supportLineBreakNewLine]><br style='mso-special-character:line-break'>
<![endif]></span></font><font face=Arial><span style='font-family:Arial'><o:p><
/o:p></span></font></p>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p>&nbsp;</o:p></span></font></p>

</div>

</FONT>
</DIV>
<DIV>
<FONT FACE="Times New Roman">&nbsp;</FONT>
</DIV>
<DIV>
<FONT FACE="Times New Roman">
</FONT>&nbsp;</DIV>
<DIV>
<FONT FACE="Times New Roman">
</FONT>&nbsp;</DIV>
<DIV>
<FONT FACE="Times New Roman">LEGAL DISCLAIMER<BR>The information transmitted is
intended solely for the individual or entity to which it is addressed and may
contain confidential and/or privileged material. Any review, retransmission,
dissemination or other use of or taking action in reliance upon this
information by persons or entities other than the intended recipient is
prohibited. If you have received this email in error please contact the sender
and delete the material from any computer.<BR>&nbsp;<BR>SunTrust and Seeing
beyond money&nbsp;are federally registered&nbsp;service marks of SunTrust Banks
, Inc.<BR>[ST:XCL]</FONT>
</DIV>
</FONT>
</DIV>
</FONT>
</DIV>
</FONT>
</DIV>
</FONT>
</DIV></BODY></HTML>