I need the Info about space allocation for tablespace
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: I need the Info about space allocation for tablespace

  1. #1
    Join Date
    May 2001
    Location
    India
    Posts
    55

    Arrow

    Hi,

    Here I am sun soloaris E250 and Oracle8i(8.1.6). Here I am doing migration operation from Oracle 7.2 to Oracle 8i. So that I looking the information about space allocation for tablespace.

    I have a Only One user but 250 tables. Each table having 100000 to 200000 laks records. How I can allocate the space for tablespace.

    If anybody knows the information about this

    just mail me along with one example like
    create tablespace xx datafile ' /../../../xx.dbf'
    storage(
    initial value
    next value
    min extents
    max extents
    pctincrease value)


    I need to create 16 tablespace for this migragtion work.

    my Email id is shankar_gk@hotmail.com,
    kgshangs@yahoo.com

    Bye,

    g.shankar



  2. #2
    Join Date
    Apr 2001
    Location
    Louisville KY
    Posts
    295
    If you do a definition only export (rows=n) on the 7.2 database, and then use Import to generate a datafile of the create statements, you will then get the necessary create statements in an editable format.

    Since tablespace size is determined by the number and size of it's data files, there are several other factors that need to be considered. Such as does your OS have a file size limit(For determining the number of files needed)? Is the OS 32 bit or 64bit (also a limiter of file size).

    You can try
    select tablespace_name,sum(bytes)/(1048576)
    from dba_extents;

    to see how big your tablespaces need to be.
    Joseph R.P. Maloney, CSP,CDP,CCP
    'The answer is 42'

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width