Skip to main content

Return to Question

deleted 14 characters in body; edited title
Source Link
marc_s
marc_s
  • 759.9k
  • 186
  • 1.4k
  • 1.5k

Copy orcaleOracle database to my local database oracle xe problem with tablespace

I am trying to copy my oracleOracle database to my local oracle xeOracle XE database. I am using Oracle SQL developerDeveloper. I

I connected to my database, then exported a .sql.sql file from my database. I I then created a new local database and I tried running the .sql.sql file against it.

when I try to run one of the create table commands I get an error when I did that:

 CREATE TABLE "user"."table_name" ::: ::: TABLESPACE "tablespace name" ; Error report - ORA-00959: tablesspace "tablespace name" does not exist  00959. 00000 - " tablespace '%s' does not exist * Cause: * Action:

Error report -
ORA-00959: tablespace "tablespace name" does not exist
00959. 00000 - " tablespace '%s' does not exist

  • Cause:
  • Action:

whatWhat is table space. should i"tablespace"? Should I remove it  ?

Copy orcale database to my local database oracle xe problem with tablespace

I am trying to copy my oracle database to my local oracle xe database. I am using Oracle SQL developer. I connected to my database then exported a .sql file from my database. I then created a new local database and I tried running the .sql file

when I try to run one of the create table commands I get an error

 CREATE TABLE "user"."table_name" ::: ::: TABLESPACE "tablespace name" ; Error report - ORA-00959: tablesspace "tablespace name" does not exist  00959. 00000 - " tablespace '%s' does not exist * Cause: * Action:

what is table space. should i remove it  ?

Copy Oracle database to my local database oracle xe problem with tablespace

I am trying to copy my Oracle database to my local Oracle XE database. I am using Oracle SQL Developer.

I connected to my database, then exported a .sql file from my database. I then created a new local database and I tried running the .sql file against it.

I get an error when I did that:

 CREATE TABLE "user"."table_name" ::: ::: TABLESPACE "tablespace name" ;

Error report -
ORA-00959: tablespace "tablespace name" does not exist
00959. 00000 - " tablespace '%s' does not exist

  • Cause:
  • Action:

What is "tablespace"? Should I remove it?

Source Link
Shahin
Shahin
  • 23
  • 5

Copy orcale database to my local database oracle xe problem with tablespace

I am trying to copy my oracle database to my local oracle xe database. I am using Oracle SQL developer. I connected to my database then exported a .sql file from my database. I then created a new local database and I tried running the .sql file

when I try to run one of the create table commands I get an error

 CREATE TABLE "user"."table_name" ::: ::: TABLESPACE "tablespace name" ; Error report - ORA-00959: tablesspace "tablespace name" does not exist 00959. 00000 - " tablespace '%s' does not exist * Cause: * Action:

what is table space. should i remove it ?