Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2006
    Posts
    15

    Unanswered: Oracle Express 4GB limitation

    I'm about to try Oracle Express for a small project. I'm not sure about how exacty this 4GB limitation works.
    In SQL Server 2005 Express, there's a 4GB limit for EACH database.
    How is in Oracle ? It sounds like it is 4Gb in total.

    How do I change the current working database using their html-based administrator? I went right directly to create a table, and it was created in "sys" databases. I could not see a way to create my own database, nor how to change the working one.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    > it was created in "sys" databases.
    You seem to be using MS SQLserver terminology when refering to Oracle objects.
    The term "database" in SQLserve is the equivalent of a schema in Oracle.
    I doubt that you'll take the time but you should read the fine Concepts Manual.
    http://download-west.oracle.com/docs...b14220/toc.htm

    Answers to all your questions can be found at
    http://www.oracle.com/pls/xe102/homepage
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Dec 2006
    Posts
    15
    You won't believe it, but 8 years ago, I read fully some of the Oracle books, the SQL Reference, Concepts, Administrator's Guide, etc. Then, in my company decided to use SQL Server 7.0 and as you can see, I forgot all of them

    Thanks for the links.
    So, don't you know by any chance if the 4GB is per schema or in total?

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >So, don't you know by any chance if the 4GB is per schema or in total?
    No, but I fail to understand why you can not run a couple of simple tests to create more than one 3 GB tables in different schemas & see what happens.
    Why would you trust input from strangers as opposed to knowing with 100% certainty for yourself?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Dec 2006
    Posts
    15
    Thanks. I've just found the answer after some reading.

    If I had to "run tests" for every single thing I learned by just reading or asking, I could not have time to do anything else.

    Again thanks for the links, I found the answer there.

Posting Permissions

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