How to add a List Partition in Oracle to an existing table having Default Partition?
930992
You cannot do this when a default partition exists.  What you have to do is issue a split of the default partition instead of an add.\n\nLook up the syntax for ALTER TABLE SPLIT PARTITION in the SQL Reference manual.  This can be done with list partitioning.
100162
Right click on Mycomputer and select MANAGE\nthen go to Disk Management, if you can see Disk1, Disk2 etc, then right click on the empty space and select create partition.
837683
We buy a program like Partition Magic\nhttp://www.powerquest.com/home_homeoffice/products/overview.jsp?pcid=sp&pvid=pm80\n\n///
409169
You can use the System.Data.OleDb namespace, which is supported in the .NET Compact Framework 2.0:\n\nhttp://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdataoledboledbconnectionclasstopic.asp\n\nTo use that, you'll need the OLE DB provider from Oracle:\n\nhttp://www.oracle.com/technology/software/tech/windows/ole_db/index.html\n\nPersonally, I'd use the .NET Framework 1.1, which includes the System.Data.OracleClient namespace:\n\nhttp://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdataoracleclient.asp\n\nThe only problem there being, eventually that framework won't be supported by Microsoft any more.
1099218
you need Oracle database to fix the error
346504
easiest way is delete the linux partition and format it. go to conntrol panel/Administrative Tools/comp managmeent under disk management if u click that u should see all the partitions... delete all the non windows partition and then rigt click on ur new empty space make it a logical drivae and voila u can format and use it again with windows. i assume  u have windows xp
1045597
you must get current value of row spli it with ', ' and insert 2 section or more of rows another time to table .therefore need to 3 functon :\nget - split - update(or insert)
1132417
Skip calling the stored proc and use a cursor to grab the rows directly and insert them into the second table.\n\nExample cursor:\n--------------------------\nDECLARE @col1_value VARCHAR(100)\nDECLARE @col2_value VARCHAR(100)\n\nDECLARE cc CURSOR FOR\nSELECT col1, col2\nFROM table1\n\nOPEN cc\n\nFETCH NEXT FROM cc INTO @col1_value, @col2_value\n\nWHILE @@FETCH_STATUS=0\nBEGIN\n\nINSERT INTO table2 (column1, column2)\nVALUES @col1_value, @col2_value\n\nEND\n\nCLOSE cc\nDEALLOCATE cc\n--------------------------
1031566
For best NFTS performance, you should format a partition as NFTS and then add files to it.  If this isn't possible, Win XP offers the CONVERT utility for converting a FAT16 or FAT32 drive to NFTS:\n\nRunning the following command at the command prompt should convert drive C: to NFTS:\n\nconvert  c:  /FS:NTFS\n\nNote, however, that if Win XP is installed on the partition you're trying to convert, you'll see the following message:\n\nConvert cannot gain exclusive access to the C:drive, so it cannot convert it now.  Would you like to schedule it to be converted the next time the system restarts?  <Y/N>\n\nIn this case, press Y to schedule the conversion.
685192
Try this free powerful partition software\nhttp://www.ranish.com/part/\nTo merge partitions, delete the 2 partitions and make 1 big partition after.
117633
I'm only answering this because I haven't seen anyone else.  I'm not an Oracle DBA, but I have extensive experience in SyBase.\n\n1) Look through your doc for a thing called sqlloader - this is the thing Oracle provides to do the job.  Basically, unloading a table using sqlloader takes the data in your table and writes it in a format that sqlloader can rewrite.\n\n2) If you are really good at PL/SQL, you can write you own unload/reload process (this is what I have to do to move data from one RDBMS to another, like from Oracle to Sybase).  Write a program that generates as output the SQL Insert statements needed to load your data.  In other words, it writes on Insert statement for every row that already exists.
252527
ok... i am guessing you are in some interactive query tool such as SQL Enterprise Manager (SQL Server) or Discoverer (Oracle). The problem is that your data isn't correctly normalized, and there are multiple rows that are equal (column A of row 1 matches column A of row 2, .... column n of row 1 matches column n of row 2). Your rows must be unique in order to use these tools to modify your data.\n\nHave you defined a primary key? If not, define one by adding a column (call it, maybe, PrimaryKey??) that is an "Identity" column in SQL Server, or a "sequence" in oracle. Then each row WILL be unique because the primary keys are unique.\n\nAre you viewing just a subset of the columns? In SQL Enterprise Manager, you can select the rows you wish to view by right-clicking on the table, then selecting OPEN, then selecting QUERY. If this is what you are doing, make sure to add your primary key to the query you're using to select and view the data. If you don't have a primary key, see the previous paragraph.\n\nIf this doesn't answer your question, email me.
916767
What are you trying to put on in its place? If it is a Windows operating system just delete the partition and recreate it as an NTFS one during the Windows installation.
149847
you could try typing "man mount"\n\nor, mount -t vfat /dev/whatever_the_partition_is /mnt
102382
When you start the installation for XP, it'll ask you to format or remove the current partition.  You can remove all partitions and reformat this way.
259577
I assume you mean to add it and then to move the database to it? Adding a HD is simple HOWEVER you should not be running an Exchange server on a single HD nor should the Database be in a single HD. What happens if that single HD fails?\n\nThe first step to to make sure you have a valid backup. If you don't have a backup then you stop everything right there. If you have a backup then shut the box down, put in your HD, prefer two and a raid card or at least software raid, get into Windows and get the drive online and formatted.\n\nYou probably want to defrag and test the database before anything else as well and this can take hours. Unless your Exchange smart I would not do any of this but here are the MS instructions. If you screw this up your going to be calling MS to get it fixed and your probably down for a day.
168128
Native XP software wont do this UNLESS you have unpartitioned space on your hard disk. Someone must have had to prepare the disk in advance by leaving more tha the 8 megs of buffer space. Best bet (unless you have unallocated space) is Partition Magic. Easy for an end user to sue with its wizards. It can move your data to make way for a new Partition safely (most of the time). If you do have adequate space then CTRL Panel-Administrative Tools - DISK MGTMT - ACTION - New Partition and choose the size FORMAT and assign a drive letter