<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
Hello, <br>
<blockquote
cite="mid:CAKFQuwaCfLjPv1UxfpkQUgN1Fh1AuZS=nHWXWKX5t-=U+9qfBg(at)mail(dot)gmail(dot)com"
type="cite">
<div dir="ltr">
<div class="gmail_extra">
<div class="gmail_quote">
<blockquote class="gmail_quote" style="margin:0px 0px 0px
0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">to
remove tablespace for primary key please?<br>
<br>
For example, z1 (c1 text) with pk_z1 PRIMARY KEY (c1),
tablespace "abc"<br>
<br>
May I know how to remove tablespace(set tablespace to
empty for z1)?<br>
</blockquote>
<div><br>
</div>
<div>
<div class="gmail_default"
style="font-family:arial,helvetica,sans-serif;display:inline">
It doesn't make sense to "remove" a tablespace...the
best you can do is change a table's (and its related
indexes) tablespace</div>
<div class="gmail_default"
style="font-family:arial,helvetica,sans-serif;display:inline"></div>
<div class="gmail_default"
style="font-family:arial,helvetica,sans-serif;display:inline">
from one to another.</div>
</div>
<div>
<div class="gmail_default"
style="font-family:arial,helvetica,sans-serif;display:inline"><br>
</div>
</div>
<div>
<div class="gmail_default"
style="font-family:arial,helvetica,sans-serif;display:inline">If
"ALTER TABLE ... SET TABLESPACE ..." doesn't accomplish
your goal you will need to explain yourself better.</div>
</div>
</div>
</div>
</div>
</blockquote>
<br>
Want to SET tablespace = '' for primary key but not table. Tried
alter index ... set tablespace='', but empty does not work? <br>
<br>
Thanks<br>
<br>
</body>
</html>