|
Anybody can tell me how can we insert data in partitioned table which is not satisfying partitioning condition.
Started by P Sharma on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Hi P Sharma,
you will get a ORA-14400 error:
SQL> CREATE TABLE t (ID NUMBER) 2 PARTITION BY RANGE (ID) 3 ( PARTITION t1 VALUES LESS THAN (100), 4 PARTITION t2 VALUES LESS THAN (200) 5 ); Table into t values (201) ~ ORA-14400: inserted....
|
|
I would like to shrink the size of a partition containing an Ubuntu distribution and files. Is it safe to assume that I will not lose or corrupt any of the files as long as I don't make the partition smaller than the amount of data that is currently on...
Started by Tim Wardle on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at serverfault):
When used correctly, and with care, you should not....
But, I have used GParted many, many times.
That you not try and shrink too close to the amount of data on the partition - leave at least 10% freeAs always, backup your data before.
|
Why does partition tool GParted read the 190GB of data twice when shrink a 250GB partition to 190GB?
When using GParted to shrink a 250GB partition to 190GB, I thought it will move the 60GB of data back into the 190GB region and call it done.
But instead it reads the 190GB of data twice, the first time taking about 1 hour and the second time for 2 hours...
Started by Jian Lin on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at superuser):
Is clicked on, it shows the 2 actions (resize and create new partition), but when the individual.
|
Ask your Facebook Friends
|
Help! i can't access my data disk!
I got 2 harddisks The first one contained one partition with Windows XP on it. the second harddisk contained one partition used only to store data(non-bootable).
So i decided to give Windows 7 RC a try and moved all ...
Started by Chris on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at serverfault):
If you can, I'd start by pulling out the data in data recovery....
If the partition table somehow got damaged on the data disk all of the data is still there.
Don't panic or do anything rash to the data disk, for starts.
|
|
I have heen trying to install OS X & Windows XP on an Apple Macbook with a third, data partition. This structure is not negotiable.
So far I have been able to install OS X 10.6 Snow Leopard and use bootcamp to install Windows XP Pro. Then I used Disk ...
Answer Snippets (Read the full thread at superuser):
Both are still GB partition....
Bootcamp to partition the drive into a large OS X partition (the size of both the data and os x the final OS X partition to be, and the second 80GB that will become the data partition.
|
|
For a range interval partitioned table, you can specify multiple tablespaces like:
CREATE TABLE range_part_interval_table(col1 NUMBER, col2 NUMBER) PARTITION BY RANGE (col1) INTERVAL (10) STORE IN (ts2, ts3, ts4) (PARTITION VALUES LESS THAN (100) TABLESPACE...
Answer Snippets (Read the full thread at stackoverflow):
But if we insert some dataThis should get you the info you need:
SELECT table_owner, table_name, partition_name, tablespace) COMPOSITE VARCHAR2(3) PARTITION_NAME....
SYS_P55 TS1 SQL>
The empty table has only the defined partition.
|
|
I have a 80 GB disk with Windows 7 taking up the entire space. It's just the OS files, no personal data, but still. I'd like to know if it is possible to make that partition smaller (about 10 GB smaller) and what are the chances of losing the data.
I ...
Answer Snippets (Read the full thread at superuser):
I'mif you free up some space, changing the partition size (shrinking) with onboard tools or 3rd party before tampering with the partition....
No data was lost.
Splitting the current partition into two and the like.
That sort of thing.
|
|
Hello.
I`d like to install Ubuntu 9.10. At the moment I have ntfs disk with Vista on it. Is it safe to install Ubuntu and choose it to use some of the free space?
Or it will just dumbly slice the disk and override any data in that part of the disk?
I ...
Started by Janis Veinbergs on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at serverfault):
UPDATE: IOW: No, it won't just dumbly slice the disk and override... .
The filesystem resizer and partition tool will move the data around on your Vista partition to make of the power going out while it's resizing the partition.
|
|
I have three external HDD's in a USB enclosure. After a recent upgrade to Win7, during which these three drives were actually installed inside the PC tower, two of the three drives now have a 200MB EFI partition, and the two drives do not show up as usable...
Started by Andy on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at superuser):
But, I have had experience....
Significant data in the EFI partition, but anyway here is how you mount it in OSX:
mkdir /Volumes/EFI mountA 200MB partition is nothing significant in today's standard, if I were you I won't mess with it.
|
|
My partition detail is like this
/dev/mapper/VolGroup00-LogVol00 57G 8.8G 46G 17% /
/dev/mapper/VolGroup00-LogVol05 259G 7.0G 239G 3% /home
/dev/mapper/VolGroup00-LogVol02 19G 493M 18G 3% /var
/dev/mapper/VolGroup00-LogVol03 19G 458M 18G 3% /tmp
/dev/...
Started by Charly on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at serverfault):
Boot with a live distro (lvm capable) don't mount your lvm partitions fsck LogVol00 and LogVol05 (twice this step) lvreduce -L-xG /dev/VolGroup00/LogVol05 resize2fs -p /dev/VolGroup00/LogVol05 do the same for /dev/mapper/VolGroup00-LogVol00 with....
|
