-
partitioning
hello
i have a table with thousands of records , now i want to go for partition .i have to do without using logical backup that is create a new table and taking a backup of the records query wise and than dump it to the new table which is partitioned.
one of my colleage is not sure of the syntax but he said to use exchange to copy the records to the new table which is partitioned.
could you please help me with the correct syntax or help me out with a solution
thank you
-
You could use CREAT TABLE ... AS SELECT ... or you could export the data and create the new partitioned object then import.
Regards
Jim
Oracle Certified Professional
"Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"
Click HERE to vist my website!
-
-
partitioning
hello jim
thst is fine
is there no keyword or sytax called exchange to transfer the records.
thanks for suggestion
-
The CREATE TABLE ... AS SELECT with create the new table structure and copy the records.
eg
if you have a table TEST and you want to create a partition table TEST2 with the values from TEST you could do something similar to the following:
Code:
create table TEST2
partition by range (id)
(partition range1 values less than (5),
partition range2 values less than (50))
as select * from TEST
Regards
Jim
Oracle Certified Professional
"Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"
Click HERE to vist my website!
-
Re: partitioning
Originally posted by ramuv
hello
i have a table with thousands of records thank you
is thousend of records enough to decide for partitioning???
remember not to forget the overhead of partitioning.
Oracle recommends this feature as must for table with > 2GB!
Orca
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|