IDS Forum

Re: Moving a single table from one database to ano

Posted By: Khaled Bentebal
Date: Wednesday, 31 August 2011, at 2:57 p.m.

In Response To: Moving a single table from one database to another (Schleicher, Keith)

You can create a synonym to the table in the new database. But this will
force you keep the original database with that particular table. That
could become a technical database; not very elegant though.

Otherwise, I do not see any other way without either:
- creating a raw table and copying the initial table to the new raw
table and dropping the original table: fastest by needs disk space
while performing the operation.
- move it to another machine: not very fast but you can use the disk
space of the other machine
- onunload/onload but you already know this route
- external tables: needs disk space
- HPL: complicated for not much
- etc.

Khaled Bentebal

Email: khaled.bentebal@consult-ix.fr

Le 31/08/11 18:55, Schleicher, Keith a écrit :
> I have a table in a database that I would like to move to a different
> database on the same dbspace. I know that I could unload the table or
> use onunload/onload, but I was wondering if there was something else
> that would be easier or faster. I don't have enough space on the
> dbspace to make a copy and then drop the original table later. This
> also looks like something we will be doing once, so I don't want any
> elaborate set up. It seems like there is a "move table" command, but it
> looks like it's only available in XPS.
>
> =20
>
> The server is running AIX 4.3.3.0 and IDS 10.00.UC5.
>
> =20
>
> Thanks in advance.
>
> =20
>
> Keith Schleicher
>
> IT Database Administrator
>
> B2-253B-A
>
> Office: 847-286-4027
>
> Cell: 224-210-8358
>
> Blackberry: 2242108358@messaging.sprintpcs.com
> <mailto:2242108358@messaging.sprintpcs.com>=20
>
> Page: 2242108358@sprint.skytel.com<mailto:2242108358@sprint.skytel.com>
>
> This message, including any attachments, is the property of Sears Holdings =
> Corporation and/or one of its subsidiaries. It is confidential and may cont=
> ain proprietary or legally privileged information. If you are not the inten=
> ded recipient, please delete it without reading the contents. Thank you.
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

Messages In This Thread

• Moving a single table from one database to another
  Schleicher, Keith -- Wednesday, 31 August 2011, at 12:55 p.m.
  • Re: Moving a single table from one database to ano
    Paul Watson -- Wednesday, 31 August 2011, at 1:06 p.m.
    • Re: Moving a single table from one database to....
      Peter_Logan@spartanstores.com -- Wednesday, 31 August 2011, at 1:17 p.m.
      • Re: Moving a single table from one database to....
        Paul Watson -- Wednesday, 31 August 2011, at 1:20 p.m.
        • Re: Moving a single table from one database to....
          Paul Watson -- Wednesday, 31 August 2011, at 1:22 p.m.
    • Re: Moving a single table from one database to....
      Jonathan Leffler -- Wednesday, 31 August 2011, at 1:24 p.m.
      • RE: Moving a single table from one database to....
        Knox, Ernest -- Wednesday, 31 August 2011, at 1:50 p.m.
    • Re: Moving a single table from one database to....
      Art Kagel -- Wednesday, 31 August 2011, at 1:57 p.m.
    • Re: Moving a single table from one database to....
      Obnoxio The Clown -- Wednesday, 31 August 2011, at 2:34 p.m.
      • Re: Moving a single table from one database to....
        Paul Watson -- Wednesday, 31 August 2011, at 2:35 p.m.
  • Re: Moving a single table from one database to ano
    Art Kagel -- Wednesday, 31 August 2011, at 2:01 p.m.
  • Re: Moving a single table from one database to ano
    MARK JALKIEWICZ -- Wednesday, 31 August 2011, at 2:31 p.m.
    • Re: Moving a single table from one database to....
      Art Kagel -- Wednesday, 31 August 2011, at 2:38 p.m.
  • Re: Moving a single table from one database to ano
    Khaled Bentebal -- Wednesday, 31 August 2011, at 2:57 p.m.
  • Re: Moving a single table from one database to ano
    Obnoxio The Clown -- Wednesday, 31 August 2011, at 7:04 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.