I'd be interested to know why you have 300 tablespaces in a database.
That seems quite excessive.
Will the data files on the test system be the same size and in the same
locations as the production data files?
Justin Cave
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC
-----Original Message-----
From: jaychopra
[mailto:oracledba-ezmlmshield-x90179672.[Email address protected]
Sent: Saturday, July 30, 2005 4:47 AM
To: LazyDBA Discussion
Subject: Create Tablesplace
Dear Friends
Hi
we have two database One is Production and Other one is Test Database In
production database there near about 300 tablespace I wants to create
same tablespace in test is there any Single query that help me to create
300 tablespace in Once , I am able to do one by one but its not good
practice
Waiting for your Expert help
Regards
Jay
-----Original Message-----
From: Anand Prakash
[mailto:oracledba-ezmlmshield-x33498563.[Email address protected]
Sent: Wednesday, July 27, 2005 3:29 AM
To: LazyDBA Discussion
Subject: RE: Unique index
Shergill
The method you suggested has a flaw.
Vijay had mentioned that the select statement has "order by" clause.
Your method would not work with "order by" clause. Cardus's method will
would.
Anand Prakash
>>> "Shergill Gurmohan "
<oracledba-ezmlmshield-x80966149.[Email address protected] 07/26/05 7:29
AM >>>
My preferred way would be:
select * from accounting_yymm where rownum < 11
minus
select * from accounting_yymm where rownum < 10
What I am doing is getting first 11 rows first ten rows first and then
first nine rows and minus-ing the first nine out of ten to get to the
tenth row. I tested it. It seems to be giving me the right and
repeatable results. However, you should know that working with the
rownum is always relative to what you are selecting and also how the
data is saved in the tables at a given time. This is why results
obtained with rownums can vary on different times. But, in this case I
don't think you need to worry abot it.
Gurmohan
www.freemath.info
-----Original Message-----
From: Cardus Ian
[mailto:oracledba-ezmlmshield-x35677522.[Email address protected]
Sent: Tuesday, July 26, 2005 9:05 AM
To: LazyDBA Discussion
Subject: RE: Unique index
That won't work (I presume you meant rownum not rowid).
This will...
select * from ( select rownum rno, t.* from <your table> t where ....)
where rno = 10;
HTH
Cardy
-----Original Message-----
From: Stacy Gaddy
[mailto:oracledba-ezmlmshield-x10791957.[Email address protected]
Sent: 26 July 2005 13:30
To: LazyDBA Discussion
Subject: Re: Unique index
If you have a consistent column that you can order by then you can use
rowid
in your where clause:
select column1, column2
from table
where rowid = 10
order by column1
Stacy
On Tuesday 26 July 2005 2:26 am, Garg Vijay wrote:
> Hi,
> I have select statement that returns 10 row. Select has order
by
> clause.
> How can I get 10th row only.
>
> Thanks
> VIJAY GARG
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
--
Stacy Gaddy
W-(919)321-0855
C-(910)376-1256
stacy.[Email address protected]
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
************************************************************************
*****
This e-mail and its attachments are confidential and are intended for
the above named recipient only. If this has come to you in error, please
notify the sender immediately and delete this e-mail from your system.
You must take no action based on this, nor must you copy or disclose it
or any part of its contents to any person or organisation. Statements
and opinions contained in this email may not necessarily represent those
of Littlewoods Group Limited or its subsidiaries. Please note that
e-mail communications may be monitored. The Registered Office of
Littlewoods Group Limited and its subsidiaries is 100 Old Hall Street,
Liverpool, L70 1AB. Registered number of Littlewoods Group Limited is
5059352.
************************************************************************
*****
This message has been scanned for viruses by BlackSpider MailControl -
www.blackspider.com
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
"MMS <firsthealth.com>" made the following annotations.
------------------------------------------------------------------------
------
This message, including any attachments, is intended solely for the use
of the named recipient(s) and may contain confidential and/or privileged
information. Any unauthorized review, use, disclosure or
distribution of this communication(s) is expressly prohibited. If you
are not the intended recipient, please contact the sender by reply
e-mail and destroy any and all copies of the original message.
Thank you.
========================================================================
======
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
******************************************
This e-mail may contain confidential and/or privileged
information. If you are not the intended recipient (or have
received this e-mail in error) please notify the sender
immediately and destroy this e-mail. Any unauthorized
copying, disclosure or distribution of the material in this
e-mail is strictly forbidden.
*******************************************
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page