Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 04 Jan 2016 @ 12:52:04 GMT


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


Subj:   Unable to create database with same name after dropping the database
 
From:   Chennapragada, Somasankaram

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



     
  <Prev Next>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023