Archives of the TeradataForum

Message Posted: Wed, 18 Aug 2004 @ 09:41:28 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi

Thank you for all for yours valuable inputs. I was worked on your guidelines, that is find out which child database have a more free prem space using following query 'Select databasename, sum(currentperm), sum(maxperm), sum(maxperm) - sum(currentperm) From dbc.diskspace Group By 1;' and I get it 'tpch' database have a free prem space is 3348480. I was tried to move from 'tpch' to 'dbc'.

I was run the following query 'CREATE DATABASE TEMP_DDI_TEMP FROM "tpch" AS perm = 1000; ' , but I still getting a same error message '2644 No more room in database dbname'. Pls give me a solution for that problem.

Thanks and Regards

Vijay

	<Prev	Next>		<<First	<Prev	Next>	Last>>