Re: problem with dbexport in IDS online 7.30 UC7

> Friends, I need some help.. I tried dbexport with a '-ss' option : > > dbexport dbname -ss > > but still it doesn't mentioned to which dbspace the tables are in thou some > tables in the database > is in a different dbspace than the rootdbs. I thought -ss would specify > the dbspace too. Or is > there some missing setup that i have not done here. What is the dafault dataspace of the database. Check onmonitor -> Status -> databases There will be an sql to check this but I don't know it. The dbexport should show any dbspace that is outside the default dbspace for the database. ie if you import a database into *myowndbspace* then all tables in that dbspace will have no mention of a dbspace in the dbexport's sql. My quess is that this is where your problem lies. If I am correct then I think you will have to resort to hacking the sql file from the dbexport. Maybe there will be a command along the lines of Alter Database set deafult dbspace ; but I'm not sure and the clown would probably be the man to ask P-) Jo > > I know the dbimport has option for dbspace but the dbexport only has the > -ss option for this > purpose. > > regards.