|
Archives of the TeradataForumMessage Posted: Mon, 04 Jan 2016 @ 12:52:04 GMT
I created a database with name 'personnel' as follows # create database personnel as perm=1e7; Now I copied 2 tables into this database from a different user. # create table emp as shankar.emp; (Cloning a table from User shankar) # create table dept as shankar.dept; # help database personnel; *** Help information returned. 2 rows. *** Total elapsed time was 1 second. Table/View/Macro name Kind Comment ------------------------------ ---- --------------------------------------- dept T ? emp T ? Now I deleted both the tables and dropped the database 'personnel' When I am trying to create the database with the same name but with different perm space, the database it not getting created. The error is as follows. BTEQ -- Enter your SQL request or BTEQ command: create database personnel as perm=1e9; <<<<<<<<< Note the change in perm space. create database personnel as perm=1e9; *** Failure 3541 The request to assign new PERMANENT space is invalid. Statement# 1, Info =0 *** Total elapsed time was 1 second. BTEQ -- Enter your SQL request or BTEQ command: sel databaseid from dbc.dbase where databasenamei='personnel'; sel databaseid from dbc.dbase where databasenamei='personnel'; *** Query completed. No rows found. *** Total elapsed time was 1 second. <<<<<<<<< This query shows that there is no personnel database existing. When I am giving the old perm space then it is creating the Database personnel; BTEQ -- Enter your SQL request or BTEQ command: create database personnel as perm=1e7; create database personnel as perm=1e7; *** Database has been created. *** Total elapsed time was 1 second. I tried to update space using updatespace utility as follows: update all space for all databases; <<<<<<<<< This did not help I restarted the database and this did not help too. Can any one help me what is going on internally. Why is it not allowing me to re-create the same database with different perm space? BR, Shankar
| ||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||
Copyright 2016 - All Rights Reserved | ||||||||||||||||||||||||||||||||||||||||||||||||
Last Modified: 15 Jun 2023 | ||||||||||||||||||||||||||||||||||||||||||||||||