Re: Spam: RE: FW: ORA-00959 -- error.

Re: Spam: RE: FW: ORA-00959 -- error.

 

  

Perhaps a tablespace transport would help.

> James-
> I'm thinking that the target tablespace must pre-exist. But the
> target table shouldn't have to pre-exist for this type of import.
> The import will create it. What's wrong with my thinking?
> Chris
>
> -----Original Message-----
> From: James
> [mailto:oracledba-ezmlmshield-x88211568.[Email address protected]
> Sent: Wednesday, November 10, 2004 4:09 PM
> To: LazyDBA Discussion
> Subject: Re: FW: ORA-00959 -- error.
>
>
> The import contains a full description of the object to be created.
> That includes the tablespace specification for the original object.
> There are two ways to move the table to a new tablespace:
> 1) pre-create a copy of the table structure in the correct tablespace
> (create table as select select from...) Now import the table with
> ignore=yes. The new table will be populated by the import.
> 2) This second option is a variation on the first one. Run the import
> using the INDEX_FILE option and do not import the data. This will
> create a text file that contains all of the SQL required to create the
> table. You can then edit that file and use it to create the table where
> you want it.
> Once the table has been created, run the import.
>
> regards,
>
> James E. Strange
>
> Database Systems Consultant Anthem IT
> Office (317) 287-5423 Fax (317) 287-5428
> Home 317 253-6154 Cell (317) 402-1742
> Oracle Certified Professional DBA
>
>
> |---------+--------------------------------------------------------->
> | | "Mohan Kumar " |
> | | <oracledba-ezmlmshield-x95459455.[Email Address Removed] | | azyDBA.com> |
> | | |
> | | 11/10/2004 06:54 PM |
> | | |
> |---------+--------------------------------------------------------->
>
>>-----------------------------------------------------------------------
> -----------------------|
> |
> |
> | To: "LazyDBA Discussion" <[Email address protected]
> |
> | cc:
> |
> | Subject: FW: ORA-00959 -- error.
> |
>
>>-----------------------------------------------------------------------
> -----------------------|
>
>
>
>
> Still looking for help.
>
> -----Original Message-----
> From: Chris Hagemaier [mailto:[Email address protected]
> Sent: Wednesday, November 10, 2004 6:53 PM
> To: Mohan Kumar
> Subject: RE: ORA-00959 -- error.
>
> That's Weird. I'm out of ideas. Foward our conversation back out to the
> the list. We need an expert on this one.
>
> -----Original Message-----
> From: Mohan Kumar [mailto:[Email address protected]
> Sent: Wednesday, November 10, 2004 3:40 PM
> To: Chris Hagemaier
> Subject: RE: ORA-00959 -- error.
>
> Did that too with no luck.
>
>
> -----Original Message-----
> From: Chris Hagemaier [mailto:[Email address protected]
> Sent: Wednesday, November 10, 2004 6:37 PM
> To: Mohan Kumar
> Subject: RE: ORA-00959 -- error.
>
> Did you try running it as the user system?
>
> IMP SYSTEM/[Email Address Removed] FILE=TEST.DMP LOG=TEST.LOG FROMUSER=OLDUSER
> TOUSER=NEWUSER IGNORE=Y GRANTS=N
>
> -----Original Message-----
> From: Mohan Kumar [mailto:[Email address protected]
> Sent: Wednesday, November 10, 2004 3:13 PM
> To: Chris Hagemaier
> Subject: RE: ORA-00959 -- error.
>
> **A LazyDBA.com subscriber has responded to your lazydba.com post**
> **LazyDBA.com mail shield has forwarded you this email, **and removed
> any attachments, and kept your email address secret **from this person,
> and any viruses/trojans.
> **If you reply to this email, the person will see your email address as
> normal **Anything below this line is the original email text
>
>
> I tried that too.
> Below is the import command I used, still no luck.
>
> IMP NEWUSER/[Email Address Removed] FILE=TEST.DMP LOG=TEST.LOG FROMUSER=OLDUSER
> TOUSER=NEWUSER IGNORE=Y GRANTS=N
>
> -----Original Message-----
> From: Chris Hagemaier
> [mailto:oracledba-ezmlmshield-x42106723.[Email address protected]
> Sent: Wednesday, November 10, 2004 6:01 PM
> To: LazyDBA Discussion
> Subject: RE: ORA-00959 -- error.
>
> I think what you need to do is use the fromuser/touser parameters during
> import and assure yourself that the user's default tablespace is NEW.
> Then it should import OK.
>
> -----Original Message-----
> From: Mohan Kumar
> [mailto:oracledba-ezmlmshield-x48566231.[Email address protected]
> Sent: Wednesday, November 10, 2004 2:28 PM
> To: LazyDBA Discussion
> Subject: ORA-00959 -- error.
>
>
> Hi All,
>
> I have a situation where one of the table column in a schema is a BLOB,
> and storage for LOB is specified to user tablespace TEST.
> When I export this schema and try to import into another database to a
> schema which uses A tablespace NEW, I am getting "ORA-00959: tablespace
> TEST does not exist" error.
> I am not sure why it is looking for same tablespace name in this new
> schema too.
>
> Please help.
> Thanks,
> Mohan.
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com To unsubscribe:
> see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com By using this list you agree
> to these terms:http://www.lazydba.com/legal.html
>
>
> --
> This message has been scanned for viruses and dangerous content by
> MailScanner, and is believed to be clean.
>
> Douglas County, Oregon
> www.co.douglas.or.us
>
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com To unsubscribe:
> see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com By using this list you agree
> to these terms:http://www.lazydba.com/legal.html
>
>
>
>
> --
> This message has been scanned for viruses and dangerous content by
> MailScanner, and is believed to be clean.
>
> Douglas County, Oregon
> www.co.douglas.or.us
>
>
> --
> This message has been scanned for viruses and dangerous content by
> MailScanner, and is believed to be clean.
>
> Douglas County, Oregon
> www.co.douglas.or.us
>
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com To unsubscribe:
> see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com By using this list you agree
> to these terms:
> http://www.lazydba.com/legal.html
>
>
>
>
>
>
>
>
> CONFIDENTIALITY NOTICE: This e-mail message, including any attachments,
> is for the sole use of the intended recipient(s) and may contain
> confidential and privileged information or otherwise protected by law.
> Any unauthorized review, use, disclosure or distribution is prohibited.
> If you are not the intended recipient, please contact the sender by
> reply e-mail and destroy all copies of the original message.
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>
>
> --
> This message has been scanned for viruses and dangerous content by
> MailScanner, and is believed to be clean.
>
> Douglas County, Oregon
> www.co.douglas.or.us
>
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these terms:http://www.lazydba.com/legal.html
>


--
Todd Pepling, Oracle DBA
420 Vineyard Dr.
Gibsonia, PA 15044
email: [Email address protected]
home: 724-444-6403
cell: 412-779-1597


Oracle LazyDBA home page