Overview Chat Bike Members News Women
  • This topic has 6 replies, 3 voices, and was last updated 6 years ago by Earl.
Viewing 7 posts - 1 through 7 (of 7 total)
  • Quick Oracle create table question.
  • Earl
    Free Member

    In oracle sql:

    Create table area1.customer (columns etc…) tablespace area2

    Is this statement valid? If so what is area1 specifying? is it a user? or a schema?

    Been a while since I had anything to do with oracle.

    Ta

    Posted 6 years ago
    Rubber_Buccaneer
    Full Member

    It’s the schema

    Posted 6 years ago
    Earl
    Free Member

    So
    area1 is the schema.
    area2 is the tablespace.

    Ta

    Posted 6 years ago
    Rubber_Buccaneer
    Full Member

    Yes

    Posted 6 years ago
    Rubber_Buccaneer
    Full Member

    Sorry for the abrupt answers, I can’t think of anything further that would be useful to add 🙂

    Posted 6 years ago
    tinribz
    Free Member

    Schema / User, tomata / tomato?

    Posted 6 years ago
    Earl
    Free Member

    No worries – thanks Rubber.

    Just trying to work out if Area1/Area2 is a typo. It’s probably not a type – but whoever named the Schema and Tablespaces on this system should be shot.

    Posted 6 years ago
Viewing 7 posts - 1 through 7 (of 7 total)

The topic ‘Quick Oracle create table question.’ is closed to new replies.

Overview Chat Bike Members News Women