12-31-2008
No, there is no conversion. Your existing idea is the only way to do this.
5 More Discussions You Might Find Interesting
1. BSD
I have done some tests with UFS/ZFS under bonnie benchmark.
here are the results if you are interested.
software:
OS: FreeBSD 7-CURRENT 200708 snapshot
benchmark: bonnie -s 2048
CFLAGS: -O2 -fno-strict-aliasing -pipe -s
CPUTYPE: athlon-mp
scheduler: ULE
hardware:
CPU: (single) Athlon... (0 Replies)
Discussion started by: vermaden
0 Replies
2. Solaris
Hello, I am new to Solaris so i apologize upfront if my questions seem trivial.
I am trying to install a ZFS file system on a Solaris 10 machine with UFS already installed on it.
I want to run: # zpool create pool_zfs c0t0d0
then: # zfs create pool_zfs/fs
My question is more to... (3 Replies)
Discussion started by: mcdef
3 Replies
3. Solaris
Hi,
Im currently having my diskspace allocation of my UFS filesystem in solris as 100% for /usr
directory.I have created a zfs pool of 3 gb.I want to allocate space from my zfs pool to /usr so that i can free space in /usr.Please help me it is quiet urgent. (6 Replies)
Discussion started by: navjotmannan
6 Replies
4. Solaris
Hello All,
Good Morning, We are trying to convert the UFS root in to ZFS. Am getting below error. Any one help me out on this ?
bash-3.00# zpool list
NAME SIZE USED AVAIL CAP HEALTH ALTROOT
guru 5.95G 483M 5.48G 7% ONLINE -
bash-3.00# zpool create rpool c2t10d0p0... (4 Replies)
Discussion started by: gowthamakanthan
4 Replies
5. Solaris
Hi..I have installed Solaris 5.10 update 9 with ZFS system with RAID1. It is to be integrated with SAN which is UFS and . It is getting mounted but when i am rebooting server,it is getting removed from system.
Pls let me know what all step need to follow for this.
Thanks !! (15 Replies)
Discussion started by: deljatt
15 Replies
LEARN ABOUT SUSE
alter_conversion
ALTER
CONVERSION(7) SQL Commands ALTER CONVERSION(7)
NAME
ALTER CONVERSION - change the definition of a conversion
SYNOPSIS
ALTER CONVERSION name RENAME TO newname
ALTER CONVERSION name OWNER TO newowner
DESCRIPTION
ALTER CONVERSION changes the definition of a conversion.
You must own the conversion to use ALTER CONVERSION. To alter the owner, you must also be a direct or indirect member of the new owning
role, and that role must have CREATE privilege on the conversion's schema. (These restrictions enforce that altering the owner doesn't do
anything you couldn't do by dropping and recreating the conversion. However, a superuser can alter ownership of any conversion anyway.)
PARAMETERS
name The name (optionally schema-qualified) of an existing conversion.
newname
The new name of the conversion.
newowner
The new owner of the conversion.
EXAMPLES
To rename the conversion iso_8859_1_to_utf8 to latin1_to_unicode:
ALTER CONVERSION iso_8859_1_to_utf8 RENAME TO latin1_to_unicode;
To change the owner of the conversion iso_8859_1_to_utf8 to joe:
ALTER CONVERSION iso_8859_1_to_utf8 OWNER TO joe;
COMPATIBILITY
There is no ALTER CONVERSION statement in the SQL standard.
SEE ALSO
CREATE CONVERSION [create_conversion(7)], DROP CONVERSION [drop_conversion(7)]
SQL - Language Statements 2010-05-14 ALTER CONVERSION(7)