Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
> 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.
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.