OraFAQ Forum: Performance Tuning » CREATE TABLE using SEQUENCE

Home » RDBMS Server » Performance Tuning » CREATE TABLE using SEQUENCE (ORacle 9i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

CREATE TABLE using SEQUENCE [message #337997]

Sat, 02 August 2008 02:49

ravashingravi
Messages: 7
Registered: March 2008
Location: India

Junior Member

Hi

I am creating a table that uses sequence. Hence i cannot use parallel hint in select clause.
Can i use PARALLEL in create table. Will this effect the sequence population. I need to populate sequence one by one as the table is already sorted.

CREATE TABLE A PARALLEL AS
SELECT /* full(b) */
x_seq.nextval COL11
COL12
COL13
FROM B b;

Table B has over 35 Million records.

Report message to a moderator

Re: CREATE TABLE using SEQUENCE [message #337999 is a reply to message #337997]

Sat, 02 August 2008 02:58

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

1/ A table is NOT sorted.
2/ Hint is useless, get rid of all of them unless you are an optimizer expert and know what you do (and you are not).
3/ Read guidelines and format your post
4/ Post your version with 4 decimals
5/ What is the question?

Regards
Michel

Report message to a moderator

Re: CREATE TABLE using SEQUENCE [message #338051 is a reply to message #337999]

Sat, 02 August 2008 15:26

sunil_v_mishra
Messages: 506
Registered: March 2005

Senior Member

What i think ravashingravi problem is something different.

As per me ravashingravi need few record of table B (which is in production) into table A. For this he is creating table A which is taking few records of B (here few records are nearly 60% size of table B)

Note :- Table B is getting updated regularly

Am i right ravashingravi?

If I am right then ravashingravi question should be what is the best way to do this?

Well ravashingravi wants to reclaim the space... Shocked

Application problem they did not do purging of data regularly Laughing

DBA is in hot seat now Wink

.. please we can't afford down time Shocked

[Updated on: Sat, 02 August 2008 15:29]

Report message to a moderator

Re: CREATE TABLE using SEQUENCE [message #338070 is a reply to message #338051]

Sun, 03 August 2008 01:48

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

As per me ravashingravi need few record of table B (which is in production) into table A. For this he is creating table A which is taking few records of B (here few records are nearly 60% size of table B)

You can interpret the question as you want but the provided query does not show any restriction on rows, so where do you get "few"?
The rest of your post is then completly useless and even surrealist, I'm surprised you are not talking about hit ratio, DBA age or color of his manager shirt ornemented with all the smileys you can find in the galery; one you should often use is Embarassed

Regards
Michel

Report message to a moderator

Previous Topic:	statspack report
Next Topic:	SQL Tuning Methods & Books

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 14:56:58 CST 2024