Re: dbschema and preserving extents and dbspaces.
Hi,
I am using 7.11 and I get dbspace and extent size, lock mode and next extent
size. when I use dbschema with -ss option.
Regards,
priti
>I am running 7.10 and 7.12. I do not get the dbspace only the extents when
>I use the -ss option. Can someone check and tell me if they get the dbspace?
Steve Berg - spb@masada.nb.com
On Wed, 14 Aug 1996, Richard Johnson wrote:
} "Rajesh N. Malhotra" <malhotra@eos.ap.org> wrote:
}
} >InformiXperts,
}
} > The dbschema utility does not preserve the dbspace in wich the table
} >lives, nor the extent sizes of the table. Some time back somebody had
} >posted a utility that preserverd these values. Could someone point me to
} >that utility? Does this utility take into account that tables might be
} >fragmented?
}
} > Any and all help appreciated.
}
} >Thanx,
}
} >Raj.
}
} Try using the "-ss" option....
}
}
} I normally use something like:
}
} dbschema -ss -t all -p all > myschema.out
If you see usage for dbschema it gives following o/p.
So you may need to give -ss option after database name. You can try following
command.
dbschema -t all -p all -d dbname -ss > filename.
USAGE :
dbschema [-t tabname] [-s user] [-p user] [-r rolename] [-f procname]
[-hd tabname] -d dbname [-ss] [filename]
-t table name or \\"all\\" for all tables
-s synonyms created by user name
or \\"all\\" for all users
-ss generate server specific syntax
-p permissions granted to user name
or \\"all\\" for all users
-r create and grant of the role
or \\"all\\" for all roles :Not a valid option for SE
-f stored procedure name
or \\"all\\" for all stored procedures
-d database name
filename is the name
of file that the SQL
script goes in.
-hd Histograms of the distribution for columns of
of a specified table, a specific table column,
or \\"all\\" for all tables.
} Richard
} richj@iquest.com
Regards,
Priti R. Jhaveri
DBA
=================================================================
Voice : (908) 508 7937
E-mail: pjhaveri@treas02.attmail.com
=================================================================